[Home] [Help]
View: PAY_GB_BALANCES_BY_DATE_V2
View Text
SELECT /*+ ORDERED USE_NL(PBTTL
, PBT
, PAF
, PDB
, PBD
, SES) */ PAF.ROWID ROW_ID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, SES.EFFECTIVE_DATE
, HR_GBBAL.CALC_ALL_BALANCES(SES.EFFECTIVE_DATE
, PAF.ASSIGNMENT_ID
, PDB.DEFINED_BALANCE_ID) VALUE
FROM PAY_BALANCE_TYPES_TL PBTTL
, PAY_BALANCE_TYPES PBT
, PER_ALL_ASSIGNMENTS_F PAF
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
, FND_SESSIONS SES
WHERE PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND (PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'GB')
AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND ( PDB.LEGISLATION_CODE = 'GB' OR PDB.BUSINESS_GROUP_ID = PAF.BUSINESS_GROUP_ID)
Columns
Name |
ROW_ID |
ASSIGNMENT_ID |
BALANCE_TYPE_ID |
BALANCE_NAME |
DEFINED_BALANCE_ID |
DATABASE_ITEM_SUFFIX |
EFFECTIVE_DATE |
VALUE |