APPS.PAY_CA_RL2_REG dependencies on PYCADAR_PKG

Line 160: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

156: legislative parameter of pay_payroll_actions for RL2 archiver
157: for the given year within same business group.
158: */
159: cursor c_all_pres is
160: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
161: ppa.legislative_parameters )
162: from pay_payroll_actions ppa
163: where ppa.report_type = 'RL2'
164: and ppa.report_qualifier = 'CAEOYRL2'

Line 187: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

183: and ppa.business_group_id = l_bus_group_id
184: and ppa.action_status = 'C'
185: and ppa.payroll_action_id = paa.payroll_action_id
186: and paa.serial_number = to_char(cp_person_id)
187: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
188: ppa.legislative_parameters) = cp_pre_org_id
189: and paa.assignment_id = cp_assignment_id;
190:
191: cursor c_get_asg_id (p_person_id number) is