DBA Data[Home] [Help]

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: