VIEW: APPS.PAY_GB_BALANCES_BY_ACTION_V

Source

View Text - Preformatted

SELECT PAA.ASSIGNMENT_ID, PAA.ASSIGNMENT_ACTION_ID, PBT.BALANCE_TYPE_ID, PBTTL.BALANCE_NAME, PDB.DEFINED_BALANCE_ID, PBD.DATABASE_ITEM_SUFFIX, pay_balance_pkg.get_value(PDB.DEFINED_BALANCE_ID, PAA.ASSIGNMENT_ACTION_ID) VALUE FROM PAY_BALANCE_TYPES_TL PBTTL , PAY_BALANCE_TYPES PBT, PAY_DEFINED_BALANCES PDB, PAY_BALANCE_DIMENSIONS PBD, PAY_ASSIGNMENT_ACTIONS PAA, PAY_RUN_RESULT_VALUES PRRV, PAY_RUN_RESULTS PRR, PAY_BALANCE_FEEDS_F FEED, PAY_ASSIGNMENT_ACTIONS PAA2 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 PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID AND PRRV.RESULT_VALUE IS NOT NULL AND PRRV.RESULT_VALUE != '0' AND PAA2.ACTION_SEQUENCE <= PAA.ACTION_SEQUENCE AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PAA2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID GROUP BY PAA.ASSIGNMENT_ID, PAA.ASSIGNMENT_ACTION_ID, PBT.BALANCE_TYPE_ID, PBTTL.BALANCE_NAME, PDB.DEFINED_BALANCE_ID, PBD.DATABASE_ITEM_SUFFIX

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID) VALUE
FROM PAY_BALANCE_TYPES_TL PBTTL
, PAY_BALANCE_TYPES PBT
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_BALANCE_FEEDS_F FEED
, PAY_ASSIGNMENT_ACTIONS PAA2
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 PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PRRV.RESULT_VALUE IS NOT NULL
AND PRRV.RESULT_VALUE != '0'
AND PAA2.ACTION_SEQUENCE <= PAA.ACTION_SEQUENCE
AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID GROUP BY PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX