1270: FROM pay_assignment_actions paa
1271: ,pay_payroll_actions ppa
1272: ,hr_lookups hrl
1273: ,pay_action_information pai
1274: ,per_time_periods ptp
1275: WHERE /* paa.assignment_id = c_assignment_id */
1276: ppa.effective_Date BETWEEN c_start_date
1277: AND c_end_date
1278: AND ppa.report_type = hrl.meaning
1316: ,pay_payroll_actions ppa
1317: ,hr_lookups hrl
1318: ,hr_assignment_set_amendments hasa
1319: ,pay_action_information pai
1320: ,per_time_periods ptp
1321: WHERE ppa.effective_Date BETWEEN c_start_date
1322: AND c_end_date
1323: AND ppa.report_type = hrl.meaning
1324: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'