[Home] [Help]
136: hr_locations hrl,
137: hr_organization_information hoi,
138: hr_all_organization_units hou,
139: fnd_common_lookups fcl,
140: pay_assignment_actions paa,
141: pay_payroll_actions ppa
142: where ppa.payroll_action_id = substr(P_PAYROLL_ACTION_ID, 28)
143: and ppa.action_type = 'X'
144: and ppa.action_status = 'C'
288:
289: Select decode(count(*), 0 ,'Y', 'N')
290: into l_lump_sum_indicator
291: From pay_payroll_actions ppa_arch,
292: pay_assignment_actions paa_arch
293: where paa_arch.assignment_action_id = p_assignment_action_id
294: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
295: and paa_arch.assignment_action_id =
296: (
294: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
295: and paa_arch.assignment_action_id =
296: (
297: select max(paa.assignment_action_id)
298: from pay_assignment_actions paa
299: where paa.payroll_action_id = ppa_arch.payroll_action_id
300: and paa.assignment_id = paa_arch.assignment_id
301: ) ;
302: -- If this is the Main Certificate
428: from -- pay_za_irp5_bal_codes irp5,
429: ff_archive_items arc,
430: ff_database_items dbi
431: where arc.context1 in (select ch.assignment_action_id
432: from pay_assignment_actions main
433: , pay_assignment_actions ch
434: where main.assignment_action_id = p_assignment_action_id
435: and ch.payroll_action_id = main.payroll_action_id
436: and ch.assignment_action_id < main.assignment_action_id
429: ff_archive_items arc,
430: ff_database_items dbi
431: where arc.context1 in (select ch.assignment_action_id
432: from pay_assignment_actions main
433: , pay_assignment_actions ch
434: where main.assignment_action_id = p_assignment_action_id
435: and ch.payroll_action_id = main.payroll_action_id
436: and ch.assignment_action_id < main.assignment_action_id
437: AND ch.assignment_id = main.assignment_id)