DBA Data[Home] [Help]

APPS.IEX_TRX_VIEW_PKG dependencies on IEX_PROMISE_DETAILS

Line 59: from iex_promISe_details

55: FUNCTION is_promised(p_delinquency_id NUMBER) RETURN NUMBER
56: IS
57: cursor c_pro IS
58: select '1'
59: from iex_promISe_details
60: where delinquency_id = p_delinquency_id
61: and status = 'COLLECTABLE';
62: l_dummy VARCHAR(1);
63: l_status NUMBER;

Line 204: from iex_promise_details

200: --End - schekuri - Date 13-Apr-2005 - Bug#4113120
201:
202: cursor c_pro(p_delinquency_id NUMBER) IS
203: select '1'
204: from iex_promise_details
205: where delinquency_id = p_delinquency_id
206: and status = 'COLLECTABLE';
207:
208: cursor c_so(p_customer_trx_id NUMBER) IS