VIEW: APPS.PAY_BALANCE_FEEDS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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