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