132: legislative parameter of pay_payroll_actions for RL2 archiver
133: for the given year within same business group.
134: */
135: cursor c_all_pres is
136: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
137: ppa.legislative_parameters )
138: from pay_payroll_actions ppa
139: where ppa.report_type = 'RL2'
140: and ppa.report_qualifier = 'CAEOYRL2'
159: and ppa.business_group_id = l_bus_group_id
160: and ppa.action_status = 'C'
161: and ppa.payroll_action_id = paa.payroll_action_id
162: and paa.serial_number = to_char(cp_person_id)
163: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
164: ppa.legislative_parameters) = cp_pre_org_id
165: and paa.assignment_id = cp_assignment_id;
166:
167: cursor c_get_asg_id (p_person_id number) is