APPS.PAY_SA_GOSI_REPORTS dependencies on PER_PHONES

Line 2894: FROM per_phones pp,

2890: AND hoi.org_information_context = 'SA_HR_BG_INFO';
2891: /* Cursor to fetch phone numbers of employee */
2892: CURSOR get_phone_number (l_phone_type VARCHAR2, l_person_id NUMBER, l_effective_date DATE) IS
2893: SELECT phone_number
2894: FROM per_phones pp,
2895: per_all_people_f pap
2896: WHERE pp.parent_id = pap.person_id
2897: AND pp.phone_type = l_phone_type
2898: AND pap.person_id = l_person_id