[Home] [Help]
50: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
51: c_start_person_id in per_all_people_f.person_id%type,
52: c_end_person_id in per_all_people_f.person_id%type) is
53: select distinct a.assignment_id,
54: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,
55: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', pa.legislative_parameters) legal_entity_id
56: from per_assignments_f a, /* Bug# 2920732 */
57: per_people_f p,
58: pay_payroll_actions pa
51: c_start_person_id in per_all_people_f.person_id%type,
52: c_end_person_id in per_all_people_f.person_id%type) is
53: select distinct a.assignment_id,
54: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,
55: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', pa.legislative_parameters) legal_entity_id
56: from per_assignments_f a, /* Bug# 2920732 */
57: per_people_f p,
58: pay_payroll_actions pa
59: where pa.payroll_action_id = c_payroll_action_id
64: (select null
65: from
66: pay_payroll_actions ppa,
67: pay_assignment_actions pac
68: where ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
69: and ppa.action_type = 'X'
70: and ppa.action_status = 'C'
71: and ppa.payroll_action_id = pac.payroll_action_id
72: and pac.assignment_id = a.assignment_id
95: and ppa2.report_qualifier='SG'
96: and to_char(ppa2.effective_date, 'YYYY') =
97: (
98: select
99: pay_core_utils.get_parameter('BASIS_YEAR', ppa_arch.legislative_parameters)
100: from
101: pay_payroll_actions ppa_arch
102: where
103: ppa_arch.payroll_action_id =
100: from
101: pay_payroll_actions ppa_arch
102: where
103: ppa_arch.payroll_action_id =
104: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
105: ) /* Bug#4888368 */
106: )
107: and not exists
108: (select null