APPS.CSM_SERVICE_REQUESTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 101: FROM hz_cust_accounts custa

97: /* Cursor to get the customer account id */
98: CURSOR c_customer_account( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
99: IS
100: SELECT custa.cust_account_id
101: FROM hz_cust_accounts custa
102: WHERE custa.status = 'A'
103: AND custa.party_id = b_customer_id;
104:
105: --115.10