APPS.IGW_REPORT_PROCESSING dependencies on PER_PHONES
Line 1243: from per_phones
1239: FUNCTION get_phone_number(v_person_id in NUMBER,
1240: v_phone_type in VARCHAR2) RETURN VARCHAR2 is
1241: v_phone_number varchar2(60);
1242: cursor c1 is select phone_number 1243: from per_phones 1244: where parent_id = v_person_id and
1245: parent_table = 'PER_ALL_PEOPLE_F' and
1246: phone_type = v_phone_type and
1247: date_to is null;