View: PAY_BALANCE_FEEDS_V

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

View Text

SELECT BF.ROWID ROW_ID
, BF.BALANCE_FEED_ID
, BF.EFFECTIVE_START_DATE
, BF.EFFECTIVE_END_DATE
, BF.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BF.LEGISLATION_CODE
, BF.BALANCE_TYPE_ID
, BF.INPUT_VALUE_ID
, BF.SCALE
, BF.LEGISLATION_SUBGROUP
, BF.LAST_UPDATE_DATE
, BF.LAST_UPDATED_BY
, BF.LAST_UPDATE_LOGIN
, BF.CREATED_BY
, BF.CREATION_DATE
, ETTL.ELEMENT_NAME ELEMENT_NAME
, ECTL.CLASSIFICATION_NAME CLASSIFICATION
, EC.BALANCE_INITIALIZATION_FLAG
, IVTL.NAME INPUT_VALUE_NAME
, HL.MEANING ADD_OR_SUBTRACT
, ET.ELEMENT_TYPE_ID
, BTTL.BALANCE_NAME
, HL2.MEANING UNIT_OF_MEASURE
, IV.UOM
FROM PAY_BALANCE_FEEDS_F BF
, PAY_BALANCE_TYPES BT
, PAY_BALANCE_TYPES_TL BTTL
, PAY_INPUT_VALUES_F IV
, PAY_INPUT_VALUES_F_TL IVTL
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_CLASSIFICATIONS EC
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
, FND_SESSIONS SES
WHERE EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID
AND ECTL.LANGUAGE = USERENV('LANG')
AND 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 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 SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN BF.EFFECTIVE_START_DATE
AND BF.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE

Columns