[Home] [Help]
View: PAY_ZA_BALANCES_BY_PERIOD_V
Product: | PAY - Payroll |
Description: | PAY_ZA_BALANCES_BY_PERIOD_V gives you a list of balances per assignment and time period.f |
Implementation/DBA Data: |
APPS.PAY_ZA_BALANCES_BY_PERIOD_V
|
View Text
SELECT PAF.ASSIGNMENT_ID
, PTP.PERIOD_NAME
, PTP.END_DATE
, PBT.BALANCE_NAME
, PBD.DATABASE_ITEM_SUFFIX
, PY_ZA_BAL.CALC_ALL_BALANCES(PTP.END_DATE
, PAF.ASSIGNMENT_ID
, PDB.DEFINED_BALANCE_ID) VALUE
, PBT.BALANCE_TYPE_ID
, PDB.DEFINED_BALANCE_ID
, PTP.TIME_PERIOD_ID
FROM PAY_BALANCE_TYPES PBT
, PER_TIME_PERIODS PTP
, PER_ASSIGNMENTS_F PAF
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
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_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_BALANCE_FEEDS_F FEED
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA
WHERE 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 PPA.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID)
AND PAF.EFFECTIVE_END_DATE = ( SELECT MAX(PAF2.EFFECTIVE_END_DATE)
FROM PER_ASSIGNMENTS_F PAF2
WHERE PAF2.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID )
Columns
Name |
ASSIGNMENT_ID |
PERIOD_NAME |
END_DATE |
BALANCE_NAME |
DATABASE_ITEM_SUFFIX |
VALUE |
BALANCE_TYPE_ID |
DEFINED_BALANCE_ID |
TIME_PERIOD_ID |