APPS.ARH_DQM_CUST_HELPER dependencies on HZ_PARTIES

Line 165: hz_parties e

161: SELECT 'Y'
162: FROM hz_cust_acct_sites a,
163: hz_party_sites c,
164: hz_matched_parties_gt d,
165: hz_parties e
166: WHERE a.cust_account_id = p_cust_account_id
167: AND a.cust_acct_site_id = p_cust_acct_site_id
168: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status
169: AND a.party_site_id = c.party_site_id

Line 182: hz_parties e

178: SELECT 'Y'
179: FROM hz_cust_acct_sites_all a,
180: hz_party_sites c,
181: hz_matched_parties_gt d,
182: hz_parties e
183: WHERE a.cust_account_id = p_cust_account_id
184: AND a.cust_acct_site_id = p_cust_acct_site_id
185: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status
186: AND a.party_site_id = c.party_site_id

Line 417: hz_parties g

413: hz_relationships c,
414: hz_cust_account_roles d,
415: hz_cust_accounts e,
416: hz_matched_parties_gt f,
417: hz_parties g
418: WHERE a.search_context_id = p_ctx_id
419: AND a.org_contact_id = p_org_contact_id
420: AND NVL(a.score,0) >= 0
421: AND a.org_contact_id = b.org_contact_id

Line 895: AND b.owner_table_name = 'HZ_PARTIES'

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
897: AND DECODE(p_status,'ALL','ALL',NVL(b.status,'A')) = p_status;
898: ret VARCHAR2(1);
899: BEGIN