1162: FROM pay_assignment_actions paa
1163: ,pay_payroll_actions ppa
1164: ,hr_lookups hrl
1165: ,pay_action_information pai
1166: ,per_time_periods ptp
1167: WHERE /* paa.assignment_id = c_assignment_id */
1168: ppa.effective_Date BETWEEN c_start_date
1169: AND c_end_date
1170: AND ppa.report_type = hrl.meaning
1208: ,pay_payroll_actions ppa
1209: ,hr_lookups hrl
1210: ,hr_assignment_set_amendments hasa
1211: ,pay_action_information pai
1212: ,per_time_periods ptp
1213: WHERE ppa.effective_Date BETWEEN c_start_date
1214: AND c_end_date
1215: AND ppa.report_type = hrl.meaning
1216: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'