APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on PYCADAR_PKG

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

350: and ppa.payroll_action_id = :payroll_action_id
351: and ppa_arch.business_group_id = ppa.business_group_id
352: and ppa_arch.effective_date = ppa.effective_date
353: and ppa_arch.report_type = ''CAEOY_RL1_AMEND_PP''
354: and pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',
355: ppa_arch.legislative_parameters) = '|| ln_pre_org_id ||'
356: and paa_arch.action_status = ''C''
357: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
358: order by paf.person_id ';

Line 518: AND pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

514: AND ppa.report_qualifier = 'CAEOY_RL1_AMEND_PPQ'
515: AND ppa.business_group_id = cp_bg_id
516: AND ppa.effective_date = cp_eff_date
517: AND paa.payroll_action_id = ppa.payroll_action_id
518: AND pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
519: ppa.legislative_parameters) = to_char(hou.organization_id));
520:
521:
522: cursor c_all_asg(cp_bg_id number,

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

533: and ppa_arch.effective_date = cp_eff_date
534: and ppa_arch.action_status = 'C'
535: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
536: and paa_arch.action_status = 'C'
537: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
538: ppa_arch.legislative_parameters) = to_char(cp_pre_org_id)
539: and to_number(paa_arch.serial_number) between
540: cp_start_person and cp_end_person;
541:

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

558: and ppa_arch.effective_date = cp_eff_date
559: and ppa_arch.action_status = 'C'
560: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
561: and paa_arch.action_status = 'C'
562: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
563: ppa_arch.legislative_parameters) = to_char(cp_pre_org_id)
564: --and to_number(paa_arch.serial_number) between
565: --cp_start_person and cp_end_person;
566: and ppr.payroll_action_id = p_payroll_action_id