View: PAY_BALANCE_FEEDS_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.PAY_BALANCE_FEEDS_D

View Text

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

Columns