VIEW: APPS.PAY_ZA_PAYROLL_ACTIONS_V

Source

View Text - Preformatted

SELECT distinct ppf.payroll_name, ppa.payroll_action_id from pay_payroll_actions ppa, pay_assignment_actions paa, per_assignments_f paf, pay_payrolls_f ppf WHERE ppa.action_type = 'H' and ppa.cheque_report = 'PYZACRED' and ppa.payroll_action_id = paa.payroll_action_id and paa.assignment_id = paf.assignment_id and paf.payroll_id = ppf.payroll_id and ppa.effective_date between paf.effective_start_date and paf.effective_end_date and ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date

View Text - HTML Formatted

SELECT DISTINCT PPF.PAYROLL_NAME
, PPA.PAYROLL_ACTION_ID
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PER_ASSIGNMENTS_F PAF
, PAY_PAYROLLS_F PPF
WHERE PPA.ACTION_TYPE = 'H'
AND PPA.CHEQUE_REPORT = 'PYZACRED'
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
AND PAF.PAYROLL_ID = PPF.PAYROLL_ID
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE