APPS.ARH_DQM_CUST_HELPER dependencies on HZ_CUST_ACCT_SITES

Line 108: hz_cust_acct_sites b

104: IS
105: CURSOR c1 IS
106: SELECT 'Y'
107: FROM hz_matched_party_sites_gt a,
108: hz_cust_acct_sites b
109: WHERE a.search_context_id = p_ctx_id
110: AND -a.party_id = p_cust_account_id
111: AND -a.party_site_id = p_cust_acct_site_id
112: AND b.cust_account_id = p_cust_account_id

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 162: FROM hz_cust_acct_sites a,

158: RETURN VARCHAR2
159: IS
160: CURSOR c1 IS
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

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 227: FROM hz_cust_acct_sites a,

223: RETURN NUMBER
224: IS
225: CURSOR c1 IS
226: SELECT NVL(b.score,0)
227: FROM hz_cust_acct_sites a,
228: hz_matched_party_sites_gt b,
229: hz_party_sites c
230: WHERE a.cust_acct_site_id = p_cust_acct_site_id
231: AND DECODE(p_status,'ALL','ALL',NVL(a.status,'A')) = p_status

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 359: hz_cust_acct_sites b

355: IS
356: CURSOR c1 IS
357: SELECT 'Y'
358: FROM hz_matched_party_sites_gt a,
359: hz_cust_acct_sites b
360: WHERE a.search_context_id = p_ctx_id
361: AND NVL(a.score,0) >= 0
362: AND a.party_site_id = b.party_site_id
363: AND b.cust_acct_site_id = p_acct_site_id

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 586: FROM hz_cust_acct_sites

582: IF p_cur_all = 'CUR' THEN
583: OPEN cv FOR
584: SELECT cust_acct_site_id,
585: cust_account_id
586: FROM hz_cust_acct_sites
587: WHERE party_site_id = p_party_site_id
588: AND DECODE(p_status,'ALL','ALL',NVL(status,'A')) = p_status;
589: ELSIF p_cur_all = 'ALL' THEN
590: OPEN cv FOR

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 659: FROM hz_cust_acct_sites b,

655: RETURN VARCHAR2
656: IS
657: CURSOR c1 IS
658: SELECT 'Y'
659: FROM hz_cust_acct_sites b,
660: hz_matched_party_sites_gt c
661: WHERE b.party_site_id = p_party_site_id
662: AND b.cust_acct_site_id = -c.party_site_id
663: AND c.search_context_id = p_ctx_id

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

Line 974: FROM hz_cust_acct_sites

970: RETURN VARCHAR2
971: IS
972: CURSOR c1 IS
973: SELECT 'Y'
974: FROM hz_cust_acct_sites
975: WHERE cust_account_id = p_cust_account_id
976: AND DECODE(p_status, 'ALL','ALL',NVL(status,'A')) = p_status;
977: lyn VARCHAR2(1);
978: BEGIN