135: ,c_legislation_code VARCHAR2) IS
136: SELECT 'Y'
137: FROM pay_assignment_actions paa
138: ,pay_payroll_actions ppa
139: ,hr_lookups hrl
140: ,pay_action_information pai
141: ,per_time_periods ptp
142:
143: WHERE paa.assignment_id = c_assignment_id
172: SELECT 'Y'
173: FROM pay_assignment_actions paa
174: ,pay_payroll_actions ppa
175: ,hr_assignment_set_amendments hasa
176: ,hr_lookups hrl
177: ,pay_action_information pai
178: ,per_time_periods ptp
179:
180: WHERE paa.assignment_id = c_assignment_id
576: FROM pay_temp_object_actions ptoa
577: ,pay_action_information pai
578: ,pay_assignment_Actions paa
579: ,pay_payroll_actions ppa
580: ,hr_lookups hrl
581: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
582: AND ptoa.object_id = paa.assignment_id
583: AND paa.payroll_action_id = ppa.payroll_action_id
584: AND ppa.effective_Date BETWEEN c_start_date