476: CURSOR c_payroll_Action_info
477: (cp_payroll_action_id IN NUMBER) IS
478: SELECT effective_date,
479: business_group_id,
480: pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
481: legislative_parameters) Legal_Employer_ID,
482: pay_mx_utility.get_parameter('TRANSFER_ASSIGNMENT_SET_ID',
483: legislative_parameters) Assignment_SET_ID
484: FROM pay_payroll_actions
478: SELECT effective_date,
479: business_group_id,
480: pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
481: legislative_parameters) Legal_Employer_ID,
482: pay_mx_utility.get_parameter('TRANSFER_ASSIGNMENT_SET_ID',
483: legislative_parameters) Assignment_SET_ID
484: FROM pay_payroll_actions
485: WHERE payroll_action_id = cp_payroll_action_id;
486:
1014: AND paf1.effective_start_date <= cp_end_date
1015: AND paf1.effective_end_date >= cp_start_date
1016: AND TO_CHAR(ppa1.effective_date, 'YYYY')
1017: = TO_CHAR(cp_end_date, 'YYYY')
1018: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
1019: ppa1.legislative_parameters) = cp_legal_employer_id
1020: ORDER BY ppa1.effective_date DESC;
1021:
1022: -- Check if runs exist after the last archiver run
1871: AND ppa.action_type = 'B'
1872: AND ppa.effective_date BETWEEN trunc(cd_end_date,'Y')
1873: and cd_end_date
1874: AND ppa.business_group_id = ln_business_group_id
1875: AND pay_mx_utility.get_legi_param_val('PROCESS',
1876: legislative_parameters) = 'MX_ANN_ADJ'
1877: AND paa.assignment_id = paf.assignment_id
1878: );
1879:
1879:
1880: CURSOR c_ann_tax_type (cp_business_group_id NUMBER
1881: ,cp_effective_date DATE
1882: ,cp_person_id NUMBER) IS
1883: SELECT pay_mx_utility.get_legi_param_val('CALC_MODE'
1884: ,legislative_parameters)
1885: ,paa.assignment_action_id
1886: FROM per_all_assignments_f paf
1887: ,pay_assignment_actions paa
1890: AND paa.payroll_action_id = ppa.payroll_action_id
1891: AND ppa.action_type = 'B'
1892: AND ppa.effective_date = cp_effective_date
1893: AND ppa.business_group_id = cp_business_group_id
1894: AND pay_mx_utility.get_legi_param_val('PROCESS'
1895: ,legislative_parameters) = 'MX_ANN_ADJ'
1896: AND paa.assignment_id = paf.assignment_id
1897: ORDER BY ppa.payroll_action_id desc;
1898: