APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 52: FROM hz_cust_acct_sites_all

48: AND STATUS = 'A';
49:
50: Cursor acct_site_csr(p_org_id number, p_party_site_id number, p_account_id number) IS
51: SELECT cust_acct_site_id
52: FROM hz_cust_acct_sites_all
53: WHERE cust_account_id = p_account_id and
54: party_site_id = p_party_site_id and
55: org_id = p_org_id and
56: status = 'A';

Line 116: AND EXISTS (SELECT '1' FROM hz_cust_acct_sites_all h2

112: FROM HZ_CUST_ACCOUNTS_ALL h1
113: WHERE h1.PARTY_ID = l_party_id
114: AND h1.STATUS = 'A'
115: AND h1.CUST_ACCOUNT_ID is not null
116: AND EXISTS (SELECT '1' FROM hz_cust_acct_sites_all h2
117: WHERE h2.party_site_id = p_party_site_id
118: AND h2.CUST_ACCOUNT_ID = h1.CUST_ACCOUNT_ID
119: AND h2.STATUS = 'A'
120: AND h2.ORG_ID = p_org_id

Line 129: AND EXISTS (SELECT '1' FROM hz_cust_acct_sites_all h2

125: FROM HZ_CUST_ACCOUNTS_ALL h1
126: WHERE h1.PARTY_ID = l_party_id
127: AND h1.STATUS = 'A'
128: AND h1.CUST_ACCOUNT_ID is not null
129: AND EXISTS (SELECT '1' FROM hz_cust_acct_sites_all h2
130: WHERE h2.party_site_id = p_party_site_id
131: AND h2.CUST_ACCOUNT_ID = h1.CUST_ACCOUNT_ID
132: AND h2.STATUS = 'A'
133: AND h2.ORG_ID = p_org_id

Line 203: FROM hz_cust_acct_sites_all

199: ) IS
200:
201: Cursor acct_site_csr(p_org_id number, p_party_site_id number, p_account_id number, p_status varchar2) IS
202: SELECT cust_acct_site_id
203: FROM hz_cust_acct_sites_all
204: WHERE cust_account_id = p_account_id and
205: party_site_id = p_party_site_id and
206: org_id = p_org_id and
207: status = p_status;