APPS.PON_USER_PROFILE_PKG dependencies on PER_PHONES

Line 995: from per_phones

991:
992: begin
993: select phone_number
994: into x_user_phone
995: from per_phones
996: where phone_type = 'W1'
997: and parent_id = l_employee_id;
998: EXCEPTION
999: WHEN OTHERS THEN

Line 1006: from per_phones

1002:
1003: begin
1004: select phone_number
1005: into x_user_fax
1006: from per_phones
1007: where phone_type = 'WF'
1008: and parent_id = l_employee_id;
1009: EXCEPTION
1010: WHEN OTHERS THEN