APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_CUST_ACCOUNTS

Line 7188: FROM HZ_CUST_ACCOUNTS c,HZ_CUST_ACCT_SITES_ALL ac

7184:
7185: ----(Party level Contact Point)
7186: CURSOR c_pl_cp(p_party_id NUMBER) IS
7187: SELECT ac.CUST_ACCT_SITE_ID
7188: FROM HZ_CUST_ACCOUNTS c,HZ_CUST_ACCT_SITES_ALL ac
7189: WHERE c.party_id=p_party_id
7190: AND c.cust_account_id = ac.cust_account_id;
7191:
7192: ----(Site level contact point)