DBA Data[Home] [Help]

APPS.PAY_MX_PAYROLL_ARCH dependencies on HR_MX_UTILITY

Line 3133: hr_mx_utility.get_bg_from_assignment(p_assignment_id);

3129: EXIT;
3130: END IF;
3131:
3132: ln_business_group_id :=
3133: hr_mx_utility.get_bg_from_assignment(p_assignment_id);
3134:
3135: ln_legal_employer_id :=
3136: hr_mx_utility.get_legal_employer(ln_business_group_id,
3137: ln_tax_unit_id);

Line 3136: hr_mx_utility.get_legal_employer(ln_business_group_id,

3132: ln_business_group_id :=
3133: hr_mx_utility.get_bg_from_assignment(p_assignment_id);
3134:
3135: ln_legal_employer_id :=
3136: hr_mx_utility.get_legal_employer(ln_business_group_id,
3137: ln_tax_unit_id);
3138: hr_utility.trace('ln_legal_employer_id = ' || ln_legal_employer_id);
3139:
3140:

Line 3884: SELECT DISTINCT hr_mx_utility.get_legal_employer(paf.business_group_id,

3880: AND cp_effective_date BETWEEN paf.effective_start_date
3881: AND paf.effective_end_date;
3882:
3883: CURSOR c_get_legal_ER IS
3884: SELECT DISTINCT hr_mx_utility.get_legal_employer(paf.business_group_id,
3885: paa.tax_unit_id)
3886: FROM per_all_assignments_f paf,
3887: pay_assignment_actions paa
3888: WHERE paa.payroll_action_id = p_payroll_action_id