VIEW: APPS.PAY_GB_BALANCES_BY_DATE_V

Source

View Text - Preformatted

SELECT PAF.ROWID ROW_ID, PAF.ASSIGNMENT_ID, PBT.BALANCE_TYPE_ID, PBTTL.BALANCE_NAME, SES.EFFECTIVE_DATE FROM PAY_BALANCE_TYPES_TL PBTTL , PAY_BALANCE_TYPES PBT, PER_ASSIGNMENTS_F PAF, FND_SESSIONS SES, 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 = PBTTL.balance_type_id AND PBTTL.LANGUAGE = userenv('LANG') AND ((PBT.LEGISLATION_CODE is null AND PBT.BUSINESS_GROUP_ID is null) OR PBT.LEGISLATION_CODE = 'GB' OR PBT.BUSINESS_GROUP_ID = PAF.BUSINESS_GROUP_ID) AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND SES.SESSION_ID = USERENV('SESSIONID') 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 PPA.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID AND PPA.EFFECTIVE_DATE <= SES.EFFECTIVE_DATE AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PAA2.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID GROUP BY PAF.ROWID, PAF.ASSIGNMENT_ID, PBT.BALANCE_TYPE_ID, PBTTL.BALANCE_NAME, SES.EFFECTIVE_DATE

View Text - HTML Formatted

SELECT PAF.ROWID ROW_ID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, SES.EFFECTIVE_DATE
FROM PAY_BALANCE_TYPES_TL PBTTL
, PAY_BALANCE_TYPES PBT
, PER_ASSIGNMENTS_F PAF
, FND_SESSIONS SES
, 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 = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND ((PBT.LEGISLATION_CODE IS NULL
AND PBT.BUSINESS_GROUP_ID IS NULL) OR PBT.LEGISLATION_CODE = 'GB' OR PBT.BUSINESS_GROUP_ID = PAF.BUSINESS_GROUP_ID)
AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND SES.SESSION_ID = USERENV('SESSIONID')
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 PPA.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA.EFFECTIVE_DATE <= SES.EFFECTIVE_DATE
AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID GROUP BY PAF.ROWID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, SES.EFFECTIVE_DATE