1160: distinct paa.assignment_id
1161: ,pai.action_context_id
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
1205: distinct paa.assignment_id
1206: ,pai.action_context_id
1207: FROM pay_assignment_actions paa
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