VIEW: APPS.PAY_ZA_BALANCES_BY_ACTION_V

Source

View Text - Preformatted

SELECT PAA.ASSIGNMENT_ID, PBT.BALANCE_NAME, PBD.DATABASE_ITEM_SUFFIX , py_za_bal.calc_all_balances(PAA.ASSIGNMENT_ACTION_ID, PDB.DEFINED_BALANCE_ID) VALUE , PAA.ASSIGNMENT_ACTION_ID, PBT.BALANCE_TYPE_ID, PDB.DEFINED_BALANCE_ID FROM PAY_BALANCE_TYPES PBT, PAY_DEFINED_BALANCES PDB, PAY_BALANCE_DIMENSIONS PBD, PAY_ASSIGNMENT_ACTIONS PAA WHERE (PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'ZA') AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID AND EXISTS ( SELECT NULL FROM PAY_INPUT_VALUES_F PIV , PAY_RUN_RESULTS PRR , PAY_PAYROLL_ACTIONS PPA2, PAY_BALANCE_FEEDS_F FEED , PAY_ASSIGNMENT_ACTIONS PAA2 WHERE PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID AND PRR.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID And PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID And PPA2.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE AND FEED.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID AND PAA2.ASSIGNMENT_ACTION_ID <= PAA.ASSIGNMENT_ACTION_ID AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PAA2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID)

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ID
, PBT.BALANCE_NAME
, PBD.DATABASE_ITEM_SUFFIX
, PY_ZA_BAL.CALC_ALL_BALANCES(PAA.ASSIGNMENT_ACTION_ID
, PDB.DEFINED_BALANCE_ID) VALUE
, PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PDB.DEFINED_BALANCE_ID
FROM PAY_BALANCE_TYPES PBT
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE (PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'ZA')
AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
AND EXISTS ( SELECT NULL
FROM PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA2
, PAY_BALANCE_FEEDS_F FEED
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
AND PRR.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA2.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND FEED.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PAA2.ASSIGNMENT_ACTION_ID <= PAA.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID)