DBA Data[Home] [Help]

APPS.PAY_CA_RL2_AMEND_MAG dependencies on PYCADAR_PKG

Line 332: pycadar_pkg.get_parameter(''TRANSMITTER_PRE'', ppa_mag.legislative_parameters )

328: and paa_arch.assignment_action_id = emp.assignment_action_id
329: and paa_arch.payroll_action_id = emp.payroll_action_id
330: and emp.business_group_id = ppa_arch.business_group_id
331: and decode(hoi.org_information3, ''Y'', hoi.organization_id, hoi.org_information20) =
332: pycadar_pkg.get_parameter(''TRANSMITTER_PRE'', ppa_mag.legislative_parameters )
333: and hoi.org_information_context =''Prov Reporting Est''
334: and to_char(hoi.organization_id) = pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)
335: order by to_number(emp.person_id)' ;
336:

Line 334: and to_char(hoi.organization_id) = pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)

330: and emp.business_group_id = ppa_arch.business_group_id
331: and decode(hoi.org_information3, ''Y'', hoi.organization_id, hoi.org_information20) =
332: pycadar_pkg.get_parameter(''TRANSMITTER_PRE'', ppa_mag.legislative_parameters )
333: and hoi.org_information_context =''Prov Reporting Est''
334: and to_char(hoi.organization_id) = pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)
335: order by to_number(emp.person_id)' ;
336:
337: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor',30);
338:

Line 391: -- pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters) -- Bug 15975598

387: AND paf.person_id BETWEEN p_stperson AND p_endperson
388: AND paf.effective_start_date <= ppa_arch.effective_date
389: AND paf.effective_end_date >= ppa_arch.start_date
390: AND decode(hoi.org_information3, 'Y', hoi.organization_id, hoi.org_information20) =
391: -- pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters) -- Bug 15975598
392: substr(p_leg_param, instr(p_leg_param,'TRANSMITTER_PRE=')+16) -- Bug 15975598
393: AND hoi.org_information_context = 'Prov Reporting Est'
394: AND hoi.organization_id = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)
395: AND paf.effective_end_date = (SELECT max(paf1.effective_end_date)

Line 394: AND hoi.organization_id = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)

390: AND decode(hoi.org_information3, 'Y', hoi.organization_id, hoi.org_information20) =
391: -- pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters) -- Bug 15975598
392: substr(p_leg_param, instr(p_leg_param,'TRANSMITTER_PRE=')+16) -- Bug 15975598
393: AND hoi.org_information_context = 'Prov Reporting Est'
394: AND hoi.organization_id = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)
395: AND paf.effective_end_date = (SELECT max(paf1.effective_end_date)
396: FROM per_all_assignments_f paf1
397: WHERE paf1.assignment_id = paf.assignment_id
398: AND paf1.effective_start_date <= p_effective_dt)