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 375: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c

371:
372: FOR cust in (
373: SELECT cust_account_id, p.party_id,
374: party_name||' '||ACCOUNT_NUMBER||' '||tax_reference || ' ' data
375: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNTS c
376: WHERE p.party_id = c.party_id
377: AND c.cust_account_id = sites.cust_account_id)
378: LOOP
379: l_party_id := cust.party_id;