APPS.HR_AMEUTIL_SS dependencies on PER_ALL_PEOPLE_F

Line 1711: CURSOR c_yos (p_person_id IN per_all_people_f.person_id%TYPE)

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

Line 2331: per_all_people_f ppf,

2327:
2328: cursor requestorPosId is
2329: select paf.position_id
2330: from per_all_assignments_f paf,
2331: per_all_people_f ppf,
2332: per_position_structures pps, per_pos_structure_versions ppsv,
2333: hr_api_transactions hat
2334: where hat.transaction_id = p_transaction_id
2335: and paf.person_id = hat.creator_person_id