APPS.HZ_CUST_ACCT_SITE_BO_PVT dependencies on HZ_CUST_ACCOUNTS

Line 233: FROM HZ_CUST_ACCOUNTS

229: l_party_id NUMBER;
230:
231: CURSOR get_party_id(l_ca_id NUMBER) IS
232: SELECT party_id
233: FROM HZ_CUST_ACCOUNTS
234: WHERE cust_account_id = l_ca_id;
235: BEGIN
236: -- Standard start of API savepoint
237: SAVEPOINT create_casu_pvt;

Line 545: FROM HZ_CUST_ACCOUNTS

541: AND status in ('A','I');
542:
543: CURSOR get_party_id(l_ca_id NUMBER) IS
544: SELECT party_id
545: FROM HZ_CUST_ACCOUNTS
546: WHERE cust_account_id = l_ca_id;
547:
548: CURSOR get_casu_id(l_cas_id NUMBER, l_su_code VARCHAR2, l_org_id NUMBER) IS
549: SELECT site_use_id

Line 1314: FROM HZ_CUST_ACCOUNTS

1310: l_party_id NUMBER;
1311:
1312: CURSOR get_party_id(l_ca_id NUMBER) IS
1313: SELECT party_id
1314: FROM HZ_CUST_ACCOUNTS
1315: WHERE cust_account_id = l_ca_id;
1316: BEGIN
1317: -- Standard start of API savepoint
1318: SAVEPOINT create_casu_v2_pvt;

Line 1627: FROM HZ_CUST_ACCOUNTS

1623: AND status in ('A','I');
1624:
1625: CURSOR get_party_id(l_ca_id NUMBER) IS
1626: SELECT party_id
1627: FROM HZ_CUST_ACCOUNTS
1628: WHERE cust_account_id = l_ca_id;
1629: BEGIN
1630: -- Standard start of API savepoint
1631: SAVEPOINT save_casu_v2_pvt;