DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on FND_LOOKUP_VALUES

Line 303: FROM fnd_lookup_values

299: RETURN BOOLEAN IS
300:
301: CURSOR c IS
302: SELECT 1
303: FROM fnd_lookup_values
304: WHERE lookup_type = 'COLLECTION_PLAN_TYPE'
305: AND meaning = p_plan_type;
306:
307: result BOOLEAN;

Line 327: FROM fnd_lookup_values

323: RETURN VARCHAR2 IS
324:
325: CURSOR c IS
326: SELECT lookup_code
327: FROM fnd_lookup_values
328: WHERE lookup_type = 'COLLECTION_PLAN_TYPE'
329: AND meaning = p_plan_type;
330:
331: l_plan_type_code VARCHAR2(30);

Line 3478: FROM fnd_lookup_values

3474: FUNCTION get_plan_type (p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
3475:
3476: CURSOR c IS
3477: SELECT meaning
3478: FROM fnd_lookup_values
3479: WHERE lookup_type = 'COLLECTION_PLAN_TYPE'
3480: AND lookup_code = p_lookup_code;
3481:
3482: ret_val VARCHAR2(80);