APPS.HZ_CUST_ACCT_CONTACT_BO_PUB dependencies on HZ_CUST_ACCOUNTS

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')

Line 177: FROM HZ_CUST_ACCOUNTS ca, HZ_PARTIES p

173: AND rownum = 1;
174:
175: CURSOR get_ca_party_id(l_ca_id NUMBER) IS
176: SELECT ca.cust_account_id, ca.party_id, p.party_type
177: FROM HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
178: WHERE ca.cust_account_id = l_ca_id
179: AND ca.party_id = p.party_id
180: AND p.status in ('A','I')
181: AND rownum = 1;