APPS.CSL_SERVICE_REQUESTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 132: SELECT custa.cust_account_id FROM hz_cust_accounts custa

128: Cursor to get the customer account id */
129: CURSOR c_customer_account
130: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
131: ) IS
132: SELECT custa.cust_account_id FROM hz_cust_accounts custa
133: WHERE custa.status = 'A'
134: AND custa.party_id = b_customer_id;
135:
136: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;