APPS.OCM_GET_EXTRL_DECSN_PUB dependencies on DUAL

Line 315: 4. Individual Recommendations will be validated against lookup code of the Recommendations type.

311: /* The following validation will be placed into the API
312: 1. Case folder Id must be of typed 'CASE'.
313: 2. The case folder status must be in 'CREATED' or 'SAVED' status.
314: 3. Recommendations type will be validated against the FND lookup type.
315: 4. Individual Recommendations will be validated against lookup code of the Recommendations type.
316: */
317: IF pg_debug = 'Y'
318: THEN
319: debug ( 'OCM_GET_EXTRL_DECSN_PUB.Get_Recommendations(+)');

Line 362: /*Individual Recommendations will be validated against lookup code of the Recommendations type */

358: and enabled_flag = 'Y'
359: and rownum =1;
360:
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

Line 403: FROM dual

399: 'O',
400: l_credit_type,
401: p_recommendations_type,
402: l_application_id
403: FROM dual
404: );
405: END LOOP;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN