[Home] [Help]
View: PAY_AU_BALANCES_BY_DATE_V2
View Text
SELECT PAF.ROWID ROW_ID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, SES.EFFECTIVE_DATE
, HR_AUBAL.CALC_ALL_BALANCES( SES.EFFECTIVE_DATE
, PAF.ASSIGNMENT_ID
, PDB.DEFINED_BALANCE_ID ) VALUE
FROM PAY_BALANCE_TYPES PBT
, PER_ASSIGNMENTS_F PAF
, FND_SESSIONS SES
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
WHERE ( PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'AU')
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')
Columns
Name |
ROW_ID |
ASSIGNMENT_ID |
BALANCE_TYPE_ID |
BALANCE_NAME |
DEFINED_BALANCE_ID |
DATABASE_ITEM_SUFFIX |
EFFECTIVE_DATE |
VALUE |