DBA Data[Home] [Help]

APPS.SR_UWQ_INTEG dependencies on HZ_CONTACT_POINTS

Line 1226: from hz_contact_points hzc, hz_parties hzp

1222: --Validate the Phone Number on a CREATE_SR scenario
1223:
1224: cursor phone_cursor_create_sr is
1225: select hzc.owner_table_id,hzp.party_number,hzp.party_type
1226: from hz_contact_points hzc, hz_parties hzp
1227: where hzc.transposed_phone_number = v_transposed_phone_number
1228: and hzc.owner_table_id = hzp.party_id
1229: and hzc.owner_table_name = 'HZ_PARTIES';
1230: