DBA Data[Home] [Help]

APPS.ARH_DQM_CUST_HELPER dependencies on HZ_CONTACT_POINTS

Line 732: hz_contact_points b

728: IS
729: CURSOR c1 IS
730: SELECT 'Y'
731: FROM hz_matched_cpts_gt a,
732: hz_contact_points b
733: WHERE a.search_context_id = p_ctx_id
734: AND a.contact_point_id = b.contact_point_id
735: AND b.owner_table_name = 'HZ_PARTY_SITES'
736: AND b.owner_table_id = p_ps_id

Line 892: hz_contact_points b

888: IS
889: CURSOR c1 IS
890: SELECT 'Y'
891: FROM hz_matched_cpts_gt a,
892: hz_contact_points b
893: WHERE a.search_context_id = p_ctx_id
894: AND a.contact_point_id = b.contact_point_id
895: AND b.owner_table_name = 'HZ_PARTIES'
896: AND b.owner_table_id = p_pty_id