APPS.AST_UWQ_SEL_PKG dependencies on HZ_CONTACT_POINTS

Line 828: FROM hz_contact_points cp, hz_parties p

824: PROCEDURE GetDtlsFromPhoneNum IS
825:
826: CURSOR C_getDtlsFromPhone(x_phonenumber varchar2 ) IS
827: SELECT cp.owner_table_id, p.party_type
828: FROM hz_contact_points cp, hz_parties p
829: WHERE cp.transposed_phone_number like x_phonenumber
830: AND cp.owner_table_name = 'HZ_PARTIES'
831: AND cp.status = 'A'
832: AND cp.owner_table_id = p.party_id;