APPS.IEX_TRX_GRID_PUB dependencies on IEX_LOOKUPS_V

Line 23: * @param p_unpaid_reason Unpaid_reason_code Possible values should comes from iex_lookups_v with lookup_type 'IEX_UNPAID_REASON'.

19: * @param x_return_status API return status
20: * @param x_msg_count Number of error messages
21: * @param x_msg_data Error message data
22: * @param p_del_ids Delinquency identifier
23: * @param p_unpaid_reason Unpaid_reason_code Possible values should comes from iex_lookups_v with lookup_type 'IEX_UNPAID_REASON'.
24: * @param x_rows_processed Number of rows updated
25: * @rep:scope internal
26: * @rep:displayname Set_Unpaid_Reason
27: * @rep:lifecycle active

Line 69: select count(*) from iex_lookups_v where lookup_type = 'IEX_UNPAID_REASON'

65: l_last_updated_by number := FND_GLOBAL.USER_ID;
66: l_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),0);
67:
68: Cursor check_code(c_unpaid_reason_code varchar2) is
69: select count(*) from iex_lookups_v where lookup_type = 'IEX_UNPAID_REASON'
70: and lookup_code = c_unpaid_reason_code
71: and enabled_flag = 'Y';
72:
73: