APPS.SR_UWQ_INTEG dependencies on CS_SR_HZ_CUST_CONT_V
Line 1217: from cs_sr_hz_cust_cont_v party, cs_sr_hz_cont_pts_p_phones_v cont
1213:
1214: cursor phone_cursor is
1215: select cont.contact_point_id,cont.phone,
1216: party.party_type 1217: from cs_sr_hz_cust_cont_v party, cs_sr_hz_cont_pts_p_phones_v cont 1218: where cont.transposed_phone_number = v_transposed_phone_number
1219: and cont.owner_table_id = party.party_id
1220: and cont.phone is not null;
1221: