DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_MX_UTILITY

Line 580: hr_mx_utility.get_legal_employer(ln_bus_grp_id, p_gre_id);

576:
577: hr_utility_trace('ln_count '||ln_count);
578:
579: ln_legal_employer_id :=
580: hr_mx_utility.get_legal_employer(ln_bus_grp_id, p_gre_id);
581:
582: hr_utility_trace('ln_legal_employer_id '||ln_legal_employer_id);
583:
584: -- get the report Implementation Date from p_legal_emp_id

Line 1858: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(

1854: hr_utility_trace ('Seniority of person '||p_person_id||
1855: ' has changed since last archiver run. IDW will'||
1856: ' be recomputed for this person.');
1857: -- Get hire anniversary date
1858: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(
1859: p_person_id,
1860: p_end_date);
1861: hr_utility_trace ('Hire anniversary date of person '||p_person_id||
1862: ' = '||fnd_date.date_to_canonical(ld_hire_anniversary));

Line 4194: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(p_person_id,

4190: ,p_curr_date IN DATE
4191: ,p_prev_date IN DATE) RETURN VARCHAR2 IS
4192: ld_hire_anniversary DATE;
4193: BEGIN
4194: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(p_person_id,
4195: p_curr_date);
4196: -- Bug 6005922
4197: IF CEIL((GREATEST(p_prev_date,ld_hire_anniversary+1)-ld_hire_anniversary)/365) =
4198: CEIL((GREATEST(p_curr_date,ld_hire_anniversary+1)-ld_hire_anniversary)/365) THEN