DBA Data[Home] [Help]

APPS.HR_AMEUTIL_SS dependencies on PER_PEOPLE_F

Line 1709: CURSOR c_yos (p_person_id IN per_people_f.person_id%TYPE)

1705: RETURN NUMBER
1706: IS
1707: ln_result NUMBER:=0;
1708:
1709: CURSOR c_yos (p_person_id IN per_people_f.person_id%TYPE)
1710: IS
1711: SELECT ROUND(SUM(MONTHS_BETWEEN(
1712: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
1713: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),