APPS.RA_CUSTOMER_TEXT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 256: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c

252:
253: FOR cust in (
254: SELECT cust_account_id, p.party_id,
255: party_name||' '||ACCOUNT_NUMBER||' '||tax_reference || ' ' data
256: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c
257: WHERE p.party_id = c.party_id
258: AND c.cust_account_id = sites.cust_account_id)
259: LOOP
260: l_party_id := cust.party_id;

Line 380: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c

376:
377: FOR cust in (
378: SELECT cust_account_id, p.party_id,
379: party_name||' '||ACCOUNT_NUMBER||' '||tax_reference || ' ' data
380: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c
381: WHERE p.party_id = c.party_id
382: AND c.cust_account_id = sites.cust_account_id)
383: LOOP
384: l_party_id := cust.party_id;