VIEW: APPS.PAY_BACKPAY_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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