PAY_VALUE_DEFINITIONS

Details

SQL_Statement
SELECT pvd.VALUE_DEFN_ID VALUE_DEFN_ID, pvd.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, pvd.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, pvd.BASE_NAME BASE_NAME, pvdtl.NAME NAME, pvd.BASE_VALUE_DEFN_ID BASE_VALUE_DEFN_ID, pvd.VALUE_GROUP_ID VALUE_GROUP_ID, pvd.CALC_TYPE_ID CALC_TYPE_ID, pvd.DATABASE_ITEM_ID DATABASE_ITEM_ID, pvd.RANGE_DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID, pvd.PARENT_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID, pvd.SOURCE_ID SOURCE_ID, pvd.SOURCE_TYPE SOURCE_TYPE, pvd.DIR_OVERRIDE_USAGE_ID DIR_OVERRIDE_USAGE_ID, pvd.ENTERPRISE_ID ENTERPRISE_ID, pvd.LEGISLATION_CODE LEGISLATION_CODE, pvd.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pvd.MODULE_ID MODULE_ID, pvd.CURRENCY_CODE CURRENCY_CODE, pvd.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pvd.CREATED_BY CREATED_BY, pvd.CREATION_DATE CREATION_DATE, pvd.LAST_UPDATE_DATE LAST_UPDATE_DATE, pvd.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pvd.LAST_UPDATED_BY LAST_UPDATED_BY, pvd.VO_NAME1 VO_NAME1, pvd.VO_NAME2 VO_NAME2, pvd.VO_NAME3 VO_NAME3, pvd.DATE_MODE, pvd.UOM UOM, pvd.PERIODICITY PERIODICITY, pvd.SEED_STATUS SEED_STATUS, pvd.SGUID SGUID, pvd.OVERRIDDEN_DB_ITEM_ID, pvd.PERIODICITY_TYPE, pvd.GEOGRAPHY_TYPE_ID FROM PAY_VALUE_DEFINITIONS_F pvd, PAY_VALUE_DEFINITIONS_TL pvdtl WHERE pvd.VALUE_DEFN_ID = pvdtl.VALUE_DEFN_ID AND pvdtl.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

pvd.VALUE_DEFN_ID VALUE_DEFN_ID,

pvd.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

pvd.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

pvd.BASE_NAME BASE_NAME,

pvdtl.NAME NAME,

pvd.BASE_VALUE_DEFN_ID BASE_VALUE_DEFN_ID,

pvd.VALUE_GROUP_ID VALUE_GROUP_ID,

pvd.CALC_TYPE_ID CALC_TYPE_ID,

pvd.DATABASE_ITEM_ID DATABASE_ITEM_ID,

pvd.RANGE_DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID,

pvd.PARENT_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID,

pvd.SOURCE_ID SOURCE_ID,

pvd.SOURCE_TYPE SOURCE_TYPE,

pvd.DIR_OVERRIDE_USAGE_ID DIR_OVERRIDE_USAGE_ID,

pvd.ENTERPRISE_ID ENTERPRISE_ID,

pvd.LEGISLATION_CODE LEGISLATION_CODE,

pvd.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

pvd.MODULE_ID MODULE_ID,

pvd.CURRENCY_CODE CURRENCY_CODE,

pvd.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pvd.CREATED_BY CREATED_BY,

pvd.CREATION_DATE CREATION_DATE,

pvd.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pvd.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pvd.LAST_UPDATED_BY LAST_UPDATED_BY,

pvd.VO_NAME1 VO_NAME1,

pvd.VO_NAME2 VO_NAME2,

pvd.VO_NAME3 VO_NAME3,

pvd.DATE_MODE,

pvd.UOM UOM,

pvd.PERIODICITY PERIODICITY,

pvd.SEED_STATUS SEED_STATUS,

pvd.SGUID SGUID,

pvd.OVERRIDDEN_DB_ITEM_ID,

pvd.PERIODICITY_TYPE,

pvd.GEOGRAPHY_TYPE_ID

FROM

PAY_VALUE_DEFINITIONS_F pvd,

PAY_VALUE_DEFINITIONS_TL pvdtl

WHERE

pvd.VALUE_DEFN_ID = pvdtl.VALUE_DEFN_ID AND pvdtl.LANGUAGE = USERENV('LANG')