DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_MX_UTILITY

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

507:
508: hr_utility_trace('ln_count '||ln_count);
509:
510: ln_legal_employer_id :=
511: hr_mx_utility.get_legal_employer(ln_bus_grp_id, p_gre_id);
512:
513: hr_utility_trace('ln_legal_employer_id '||ln_legal_employer_id);
514:
515: -- get the report Implementation Date from p_legal_emp_id

Line 1773: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(

1769: hr_utility_trace ('Seniority of person '||p_person_id||
1770: ' has changed since last archiver run. IDW will'||
1771: ' be recomputed for this person.');
1772: -- Get hire anniversary date
1773: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(
1774: p_person_id,
1775: p_end_date);
1776: hr_utility_trace ('Hire anniversary date of person '||p_person_id||
1777: ' = '||fnd_date.date_to_canonical(ld_hire_anniversary));

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

3953: ,p_curr_date IN DATE
3954: ,p_prev_date IN DATE) RETURN VARCHAR2 IS
3955: ld_hire_anniversary DATE;
3956: BEGIN
3957: ld_hire_anniversary := hr_mx_utility.get_hire_anniversary(p_person_id,
3958: p_curr_date);
3959: -- Bug 6005922
3960: IF CEIL((GREATEST(p_prev_date,ld_hire_anniversary+1)-ld_hire_anniversary)/365) =
3961: CEIL((GREATEST(p_curr_date,ld_hire_anniversary+1)-ld_hire_anniversary)/365) THEN