1170: distinct paa.assignment_id
1171: ,pai.action_context_id
1172: FROM pay_assignment_actions paa
1173: ,pay_payroll_actions ppa
1174: ,hr_lookups hrl
1175: ,pay_action_information pai
1176: ,per_time_periods ptp
1177: WHERE /* paa.assignment_id = c_assignment_id */
1178: ppa.effective_Date BETWEEN c_start_date
1215: distinct paa.assignment_id
1216: ,pai.action_context_id
1217: FROM pay_assignment_actions paa
1218: ,pay_payroll_actions ppa
1219: ,hr_lookups hrl
1220: ,hr_assignment_set_amendments hasa
1221: ,pay_action_information pai
1222: ,per_time_periods ptp
1223: WHERE ppa.effective_Date BETWEEN c_start_date