DBA Data[Home] [Help]

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;