APPS.ARW_SEARCH_CUSTOMERS dependencies on CONTAINS

Line 231: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

227: FROM hz_cust_acct_sites_all adr,
228: hz_cust_accounts cus,
229: hz_parties party,
230: ar_system_parameters_all sys
231: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0
232: AND adr.cust_account_id = cus.cust_account_id
233: AND cus.party_id = party.party_id
234: AND adr.org_id = sys.org_id ;
235: ORDER BY score(1) desc, cus.cust_account_id,

Line 242: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

238: /* Bug2288089: Removed _all for hz_cust_acct_sites */
239: CURSOR ctx_cur (p_keyword VARCHAR2) IS
240: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
241: FROM hz_cust_acct_sites adr
242: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0
243: ORDER BY score(1) desc;
244:
245: l_cust_tab cust_tab;
246: l_rev_cust_tab rev_cust_tab;