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 3718: FROM fnd_lookup_values

3714: FUNCTION get_plan_type (p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
3715:
3716: CURSOR c IS
3717: SELECT meaning
3718: FROM fnd_lookup_values
3719: WHERE lookup_type = 'COLLECTION_PLAN_TYPE'
3720: AND lookup_code = p_lookup_code;
3721:
3722: ret_val VARCHAR2(80);