DBA Data[Home] [Help]

APPS.ARH_DQM_CUST_HELPER dependencies on HZ_ORG_CONTACTS

Line 412: hz_org_contacts b,

408: d.cust_account_role_id,
409: d.cust_account_id,
410: d.cust_acct_site_id
411: FROM hz_matched_contacts_gt a,
412: hz_org_contacts b,
413: hz_relationships c,
414: hz_cust_account_roles d,
415: hz_cust_accounts e,
416: hz_matched_parties_gt f,

Line 706: hz_org_contacts b

702: IS
703: CURSOR c1 IS
704: SELECT 'Y'
705: FROM hz_matched_contacts_gt a,
706: hz_org_contacts b
707: WHERE a.search_context_id = p_ctx_id
708: AND NVL(a.score,0) >= 0
709: AND a.org_contact_id = b.org_contact_id
710: AND b.party_site_id = p_ps_id