DBA Data[Home] [Help]

APPS.PAY_CA_RL2_REG dependencies on PYCADAR_PKG

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

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'

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

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