APPS.HZ_PARTY_V2PUB dependencies on HZ_CUST_ACCOUNTS

Line 8972: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS c,

8968: p_new_tax_reference IN VARCHAR2)
8969: IS
8970: CURSOR c_cust_acct_sites(p_party_id NUMBER) IS
8971: SELECT ac.CUST_ACCT_SITE_ID
8972: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS c,
8973: HZ_CUST_ACCT_SITES_ALL ac
8974: WHERE p.party_id=p_party_id
8975: AND p.party_id = c.party_id
8976: AND c.cust_account_id = ac.cust_account_id;