View: PAY_BACKPAY_RULES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_BACKPAY_RULES_V

View Text

SELECT BR.ROWID ROW_ID
, BR.DEFINED_BALANCE_ID
, BR.INPUT_VALUE_ID
, BR.BACKPAY_SET_ID
, BT.BALANCE_NAME||BM.DATABASE_ITEM_SUFFIX BALANCE_TYPE_NAME
, BT.BALANCE_TYPE_ID
, IVTL.NAME INPUT_VALUE_NAME
, ETTL.ELEMENT_NAME
, ET.ELEMENT_TYPE_ID
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
, BR.LAST_UPDATE_LOGIN
, BR.CREATED_BY
, BR.CREATION_DATE
FROM PAY_BACKPAY_RULES BR
, PAY_INPUT_VALUES_F_TL IVTL
, PAY_INPUT_VALUES_F IV
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
, PAY_DEFINED_BALANCES BD
, PAY_BALANCE_TYPES BT
, PAY_BALANCE_DIMENSIONS BM
, FND_SESSIONS FND
WHERE ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE = USERENV('LANG')
AND IV.INPUT_VALUE_ID = IVTL.INPUT_VALUE_ID
AND IVTL.LANGUAGE = USERENV('LANG')
AND BR.DEFINED_BALANCE_ID = BD.DEFINED_BALANCE_ID
AND BT.BALANCE_TYPE_ID = BD.BALANCE_TYPE_ID
AND BD.BALANCE_DIMENSION_ID = BM.BALANCE_DIMENSION_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND BR.INPUT_VALUE_ID = IV.INPUT_VALUE_ID
AND FND.EFFECTIVE_DATE BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND IV.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
AND FND.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE

Columns