APPS.HZ_CUST_ACCT_CONTACT_BO_PUB dependencies on HZ_CUST_ACCT_SITES

Line 168: FROM HZ_CUST_ACCT_SITES cas, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p

164: l_valid_per VARCHAR2(1);
165:
166: CURSOR get_cas_party_id(l_cas_id NUMBER) IS
167: SELECT ca.cust_account_id, cas.cust_acct_site_id, ca.party_id, p.party_type
168: FROM HZ_CUST_ACCT_SITES cas, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
169: WHERE cas.cust_acct_site_id = l_cas_id
170: AND cas.cust_account_id = ca.cust_account_id
171: AND ca.party_id = p.party_id
172: AND p.status in ('A','I')