DBA Data[Home] [Help]

APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_CUST_ACCOUNTS

Line 7032: FROM HZ_CUST_ACCOUNTS c,HZ_CUST_ACCT_SITES_ALL ac

7028:
7029: ----(Party level Contact Point)
7030: CURSOR c_pl_cp(p_party_id NUMBER) IS
7031: SELECT ac.CUST_ACCT_SITE_ID
7032: FROM HZ_CUST_ACCOUNTS c,HZ_CUST_ACCT_SITES_ALL ac
7033: WHERE c.party_id=p_party_id
7034: AND c.cust_account_id = ac.cust_account_id;
7035:
7036: ----(Site level contact point)