APPS.PAY_MX_YREND_ARCH dependencies on PAY_MX_UTILITY

Line 321: pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',

317: CURSOR c_payroll_Action_info
318: (cp_payroll_action_id IN NUMBER) IS
319: SELECT effective_date,
320: business_group_id,
321: pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
322: legislative_parameters) Legal_Employer_ID,
323: pay_mx_utility.get_parameter('TRANSFER_ASSIGNMENT_SET_ID',
324: legislative_parameters) Assignment_SET_ID
325: FROM pay_payroll_actions

Line 323: pay_mx_utility.get_parameter('TRANSFER_ASSIGNMENT_SET_ID',

319: SELECT effective_date,
320: business_group_id,
321: pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
322: legislative_parameters) Legal_Employer_ID,
323: pay_mx_utility.get_parameter('TRANSFER_ASSIGNMENT_SET_ID',
324: legislative_parameters) Assignment_SET_ID
325: FROM pay_payroll_actions
326: WHERE payroll_action_id = cp_payroll_action_id;
327:

Line 1629: AND pay_mx_utility.get_legi_param_val('PROCESS',

1625: AND ppa.action_type = 'B'
1626: AND ppa.effective_date BETWEEN trunc(cd_end_date,'Y')
1627: and cd_end_date
1628: AND ppa.business_group_id = ln_business_group_id
1629: AND pay_mx_utility.get_legi_param_val('PROCESS',
1630: legislative_parameters) = 'MX_ANN_ADJ'
1631: AND paa.assignment_id = paf.assignment_id
1632: );
1633:

Line 1637: SELECT pay_mx_utility.get_legi_param_val('CALC_MODE'

1633:
1634: CURSOR c_ann_tax_type (cp_business_group_id NUMBER
1635: ,cp_effective_date DATE
1636: ,cp_person_id NUMBER) IS
1637: SELECT pay_mx_utility.get_legi_param_val('CALC_MODE'
1638: ,legislative_parameters)
1639: ,paa.assignment_action_id
1640: FROM per_all_assignments_f paf
1641: ,pay_assignment_actions paa

Line 1648: AND pay_mx_utility.get_legi_param_val('PROCESS'

1644: AND paa.payroll_action_id = ppa.payroll_action_id
1645: AND ppa.action_type = 'B'
1646: AND ppa.effective_date = cp_effective_date
1647: AND ppa.business_group_id = cp_business_group_id
1648: AND pay_mx_utility.get_legi_param_val('PROCESS'
1649: ,legislative_parameters) = 'MX_ANN_ADJ'
1650: AND paa.assignment_id = paf.assignment_id
1651: ORDER BY ppa.payroll_action_id desc;
1652: