APPS.CSM_SERVICE_REQUESTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 80: FROM hz_cust_accounts custa

76: /* Cursor to get the customer account id */
77: CURSOR c_customer_account ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
78: IS
79: SELECT custa.cust_account_id
80: FROM hz_cust_accounts custa
81: WHERE custa.status = 'A'
82: AND custa.party_id = b_customer_id;
83:
84: /* Cursor to select object_version_number */