APPS.ARH_DQM_CUST_HELPER dependencies on HZ_CUST_ACCT_SITES_ALL

Line 120: hz_cust_acct_sites_all b

116:
117: CURSOR c2 IS
118: SELECT 'Y'
119: FROM hz_matched_party_sites_gt a,
120: hz_cust_acct_sites_all b
121: WHERE a.search_context_id = p_ctx_id
122: AND -a.party_id = p_cust_account_id
123: AND -a.party_site_id = p_cust_acct_site_id
124: AND b.cust_account_id = p_cust_account_id

Line 179: FROM hz_cust_acct_sites_all a,

175: AND DECODE(p_status,'ALL','ALL',NVL(e.status,'A')) = p_status;
176:
177: CURSOR c2 IS
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

Line 240: FROM hz_cust_acct_sites_all a,

236: AND DECODE(p_status,'ALL','ALL',NVL(c.status,'A')) = p_status;
237:
238: CURSOR c2 IS
239: SELECT NVL(b.score,0)
240: FROM hz_cust_acct_sites_all a,
241: hz_matched_party_sites_gt b,
242: hz_party_sites c
243: WHERE a.cust_acct_site_id = p_cust_acct_site_id
244: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status

Line 369: hz_cust_acct_sites_all b

365:
366: CURSOR c2 IS
367: SELECT 'Y'
368: FROM hz_matched_party_sites_gt a,
369: hz_cust_acct_sites_all b
370: WHERE a.search_context_id = p_ctx_id
371: AND NVL(a.score,0) >= 0
372: AND a.party_site_id = b.party_site_id
373: AND b.cust_acct_site_id = p_acct_site_id

Line 593: FROM hz_cust_acct_sites_all

589: ELSIF p_cur_all = 'ALL' THEN
590: OPEN cv FOR
591: SELECT cust_acct_site_id,
592: cust_account_id
593: FROM hz_cust_acct_sites_all
594: WHERE party_site_id = p_party_site_id
595: AND DECODE(p_status,'ALL','ALL',NVL(status,'A')) = p_status;
596: END IF;
597:

Line 669: FROM hz_cust_acct_sites_all b,

665: AND DECODE(p_status,'ALL','ALL',NVL(b.status,'A')) = p_status;
666:
667: CURSOR c2 IS
668: SELECT 'Y'
669: FROM hz_cust_acct_sites_all b,
670: hz_matched_party_sites_gt c
671: WHERE b.party_site_id = p_party_site_id
672: AND b.cust_acct_site_id = -c.party_site_id
673: AND c.search_context_id = p_ctx_id