DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on PYCADAR_PKG

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

265: legislative parameter of pay_payroll_actions for RL1 archiver
266: for the given year within same business group.
267: */
268: cursor c_all_pres is
269: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
270: ppa.legislative_parameters )
271: from pay_payroll_actions ppa
272: where ppa.report_type = 'RL1'
273: and ppa.report_qualifier = 'CAEOYRL1'

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

292: and ppa.business_group_id = l_bus_group_id
293: and ppa.action_status = 'C'
294: and ppa.payroll_action_id = paa.payroll_action_id
295: and paa.serial_number = to_char(cp_person_id)
296: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
297: ppa.legislative_parameters) = cp_pre_org_id
298: and paa.assignment_id = cp_assignment_id;
299:
300: cursor c_first_tax_unit_id (p_pre_org_id varchar2) is