VIEW: APPS.PAY_BALANCE_FEEDS_D

Source

View Text - Preformatted

SELECT BF.BALANCE_FEED_ID , BF.EFFECTIVE_START_DATE , BF.EFFECTIVE_END_DATE , IVTL.NAME , BTTL.BALANCE_NAME , HL2.MEANING , HL.MEANING , BF.LAST_UPDATE_DATE , FU.USER_NAME FROM PAY_BALANCE_TYPES_TL BTTL , PAY_BALANCE_FEEDS_F BF , PAY_BALANCE_TYPES BT , PAY_INPUT_VALUES_F_TL IVTL , PAY_INPUT_VALUES_F IV , PAY_ELEMENT_TYPES_F ET , PAY_ELEMENT_CLASSIFICATIONS EC , HR_LOOKUPS HL , HR_LOOKUPS HL2 , FND_USER FU WHERE IV.input_value_id = IVTL.input_value_id AND IVTL.language = userenv('LANG') AND BT.balance_type_id = BTTL.balance_type_id AND BTTL.language = userenv('LANG') AND BT.BALANCE_TYPE_ID = BF.BALANCE_TYPE_ID AND IV.INPUT_VALUE_ID = BF.INPUT_VALUE_ID AND ET.ELEMENT_TYPE_ID = IV.ELEMENT_TYPE_ID AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID AND HL.LOOKUP_TYPE = 'ADD_SUBTRACT' AND HL.LOOKUP_CODE = BF.SCALE AND HL2.LOOKUP_TYPE = 'UNITS' AND HL2.LOOKUP_CODE = IV.UOM AND BF.EFFECTIVE_START_DATE BETWEEN IV.EFFECTIVE_START_DATE AND IV.EFFECTIVE_END_DATE AND BF.EFFECTIVE_START_DATE BETWEEN ET.EFFECTIVE_START_DATE AND ET.EFFECTIVE_END_DATE AND FU.USER_ID (+)= BF.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT BF.BALANCE_FEED_ID
, BF.EFFECTIVE_START_DATE
, BF.EFFECTIVE_END_DATE
, IVTL.NAME
, BTTL.BALANCE_NAME
, HL2.MEANING
, HL.MEANING
, BF.LAST_UPDATE_DATE
, FU.USER_NAME
FROM PAY_BALANCE_TYPES_TL BTTL
, PAY_BALANCE_FEEDS_F BF
, PAY_BALANCE_TYPES BT
, PAY_INPUT_VALUES_F_TL IVTL
, PAY_INPUT_VALUES_F IV
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_CLASSIFICATIONS EC
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
, FND_USER FU
WHERE IV.INPUT_VALUE_ID = IVTL.INPUT_VALUE_ID
AND IVTL.LANGUAGE = USERENV('LANG')
AND BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID
AND BTTL.LANGUAGE = USERENV('LANG')
AND BT.BALANCE_TYPE_ID = BF.BALANCE_TYPE_ID
AND IV.INPUT_VALUE_ID = BF.INPUT_VALUE_ID
AND ET.ELEMENT_TYPE_ID = IV.ELEMENT_TYPE_ID
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND HL.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HL.LOOKUP_CODE = BF.SCALE
AND HL2.LOOKUP_TYPE = 'UNITS'
AND HL2.LOOKUP_CODE = IV.UOM
AND BF.EFFECTIVE_START_DATE BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND BF.EFFECTIVE_START_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND FU.USER_ID (+)= BF.LAST_UPDATED_BY