APPS.CSC_RESPONSE_CENTER_PKG dependencies on HZ_CUST_ACCOUNTS

Line 184: FROM hz_cust_accounts

180:
181: --
182: CURSOR Get_Oldest_Acct(p_party_id NUMBER) IS
183: SELECT account_name, account_number,cust_account_id, object_version_number
184: FROM hz_cust_accounts
185: WHERE party_id=p_party_id
186: AND ((status = 'A' AND l_account_status = 'Y') OR (l_account_status = 'N'))
187: AND status not in ('M', 'D')
188: ORDER BY creation_date ASC;

Line 192: FROM hz_cust_accounts

188: ORDER BY creation_date ASC;
189:
190: CURSOR Get_Latest_Acct(p_party_id NUMBER) IS
191: SELECT account_name, account_number,cust_account_id, object_version_number
192: FROM hz_cust_accounts
193: WHERE party_id=p_party_id
194: AND ((status = 'A' AND l_account_status = 'Y') OR (l_account_status = 'N'))
195: AND status not in ('M', 'D')
196: ORDER BY creation_date DESC;