APPS.OCM_GET_EXTRL_DECSN_PUB dependencies on FND_LOOKUPS

Line 307: l_lookup_type fnd_lookups.lookup_type%type;

303: l_case_folder_type ar_cmgt_case_folders.type%type;
304: l_case_folder_status ar_cmgt_case_folders.status%type;
305: l_credit_request_id ar_cmgt_case_folders.credit_request_id%type;
306: l_credit_type ar_cmgt_credit_requests.credit_type%type;
307: l_lookup_type fnd_lookups.lookup_type%type;
308: l_application_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
309:
310: BEGIN
311: /* The following validation will be placed into the API

Line 356: from fnd_lookups

352: /* validation of Recommendations type */
353: BEGIN
354: select LOOKUP_TYPE
355: into l_lookup_type
356: from fnd_lookups
357: where lookup_type = p_recommendations_type
358: and enabled_flag = 'Y'
359: and rownum =1;
360:

Line 365: from fnd_lookups

361: FOR i in 1 .. p_recommendations_tbl.count LOOP
362: /*Individual Recommendations will be validated against lookup code of the Recommendations type */
363: select LOOKUP_TYPE
364: into l_lookup_type
365: from fnd_lookups
366: where lookup_type = p_recommendations_type
367: and enabled_flag = 'Y'
368: and lookup_code = p_recommendations_tbl(i).Credit_Recommendation;
369: