VIEW: APPS.PAY_SG_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 = ppa.business_group_id) or pbt.legislation_code = 'SG') 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 = PPA.BUSINESS_GROUP_ID) OR PBT.LEGISLATION_CODE = 'SG')
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