VIEW: APPS.PAY_JP_BALANCES_BY_ACTION_V

Source

View Text - Preformatted

SELECT ASSACT.ASSIGNMENT_ID, ASSACT.ASSIGNMENT_ACTION_ID, PBT.BALANCE_TYPE_ID, PBT.BALANCE_NAME, PDB.DEFINED_BALANCE_ID, PBD.DATABASE_ITEM_SUFFIX, hr_jpbal.calc_all_balances(ASSACT.ASSIGNMENT_ACTION_ID, PDB.DEFINED_BALANCE_ID) VALUE FROM PAY_BALANCE_DIMENSIONS PBD, PAY_DEFINED_BALANCES PDB, PAY_BALANCE_TYPES PBT, PAY_BALANCE_FEEDS_F FEED, PAY_RUN_RESULT_VALUES PRRV, PAY_RUN_RESULTS PRR, PAY_PAYROLL_ACTIONS PACT, PAY_ASSIGNMENT_ACTIONS ASSACT WHERE ASSACT.ACTION_STATUS = 'C' AND PACT.PAYROLL_ACTION_ID = ASSACT.PAYROLL_ACTION_ID AND PRR.ASSIGNMENT_ACTION_ID = ASSACT.ASSIGNMENT_ACTION_ID AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID AND PACT.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE AND FEED.EFFECTIVE_END_DATE AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID AND NVL(PBT.LEGISLATION_CODE,'JP') = 'JP' AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID GROUP BY ASSACT.ASSIGNMENT_ID, ASSACT.ASSIGNMENT_ACTION_ID, PBT.BALANCE_TYPE_ID, PBT.BALANCE_NAME, PDB.DEFINED_BALANCE_ID, PBD.DATABASE_ITEM_SUFFIX

View Text - HTML Formatted

SELECT ASSACT.ASSIGNMENT_ID
, ASSACT.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, HR_JPBAL.CALC_ALL_BALANCES(ASSACT.ASSIGNMENT_ACTION_ID
, PDB.DEFINED_BALANCE_ID) VALUE
FROM PAY_BALANCE_DIMENSIONS PBD
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_FEEDS_F FEED
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PACT
, PAY_ASSIGNMENT_ACTIONS ASSACT
WHERE ASSACT.ACTION_STATUS = 'C'
AND PACT.PAYROLL_ACTION_ID = ASSACT.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID = ASSACT.ASSIGNMENT_ACTION_ID
AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PACT.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE
AND FEED.EFFECTIVE_END_DATE
AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
AND NVL(PBT.LEGISLATION_CODE
, 'JP') = 'JP'
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID GROUP BY ASSACT.ASSIGNMENT_ID
, ASSACT.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX