[Home] [Help]
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
167: AND a.cust_acct_site_id = p_cust_acct_site_id
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
184: AND a.cust_acct_site_id = p_cust_acct_site_id
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
232: AND a.party_site_id = b.party_site_id
233: AND b.search_context_id = p_ctx_id
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
245: AND a.party_site_id = b.party_site_id
246: AND b.search_context_id = p_ctx_id
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
737: AND DECODE(p_status,'ALL','ALL',NVL(b.status,'A')) = p_status;
738: ret VARCHAR2(1);
739: BEGIN