[Home] [Help]
334: and ppa.payroll_action_id = :payroll_action_id
335: and ppa_arch.business_group_id = ppa.business_group_id
336: and ppa_arch.effective_date = ppa.effective_date
337: and ppa_arch.report_type = ''CAEOY_RL2_AMEND_PP''
338: and pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',
339: ppa_arch.legislative_parameters) = '|| ln_pre_org_id ||'
340: and paa_arch.action_status = ''C''
341: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
342: order by paf.person_id ';
497: AND ppa.report_qualifier = 'CAEOY_RL2_AMEND_PPQ'
498: AND ppa.business_group_id = cp_bg_id
499: AND ppa.effective_date = cp_eff_date
500: AND paa.payroll_action_id = ppa.payroll_action_id
501: AND pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
502: ppa.legislative_parameters) = to_char(hou.organization_id));
503:
504: cursor c_all_asg(cp_bg_id number,
505: cp_pre_org_id number,
515: and ppa_arch.effective_date = cp_eff_date
516: and ppa_arch.action_status = 'C'
517: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
518: and paa_arch.action_status = 'C'
519: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
520: ppa_arch.legislative_parameters) = to_char(cp_pre_org_id)
521: and to_number(paa_arch.serial_number) between
522: cp_start_person and cp_end_person;
523:
538: and ppa_arch.effective_date = cp_eff_date
539: and ppa_arch.action_status = 'C'
540: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
541: and paa_arch.action_status = 'C'
542: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
543: ppa_arch.legislative_parameters) = to_char(cp_pre_org_id)
544: --and to_number(paa_arch.serial_number) between
545: --cp_start_person and cp_end_person;
546: and ppr.payroll_action_id = p_payroll_action_id