DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 60: FROM hz_cust_site_uses_all

56: status = 'A';
57:
58: Cursor acct_site_use_csr(p_cust_acct_site_id number, p_site_use_code varchar2) IS
59: SELECT site_use_id
60: FROM hz_cust_site_uses_all
61: WHERE cust_acct_site_id = p_cust_acct_site_id and
62: site_use_code = p_site_use_code and
63: status = 'A';
64:

Line 211: FROM hz_cust_site_uses_all

207: status = p_status;
208:
209: Cursor acct_site_use_csr(p_cust_acct_site_id number, p_site_use_code varchar2, p_status varchar2) IS
210: SELECT site_use_id
211: FROM hz_cust_site_uses_all
212: WHERE cust_acct_site_id = p_cust_acct_site_id and
213: site_use_code = p_site_use_code and
214: status = p_status;
215: