DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on PYCADAR_PKG

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

239: legislative parameter of pay_payroll_actions for RL1 archiver
240: for the given year within same business group.
241: */
242: cursor c_all_pres is
243: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
244: ppa.legislative_parameters )
245: from pay_payroll_actions ppa
246: where ppa.report_type = 'RL1'
247: and ppa.report_qualifier = 'CAEOYRL1'

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

266: and ppa.business_group_id = l_bus_group_id
267: and ppa.action_status = 'C'
268: and ppa.payroll_action_id = paa.payroll_action_id
269: and paa.serial_number = to_char(cp_person_id)
270: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
271: ppa.legislative_parameters) = cp_pre_org_id
272: and paa.assignment_id = cp_assignment_id;
273:
274: cursor c_first_tax_unit_id (p_pre_org_id varchar2) is