APPS.FND_FLEX_TYPES dependencies on FND_LOOKUPS

Line 10: FROM fnd_lookups

6: PROCEDURE validate_type(typ IN VARCHAR2, code IN VARCHAR2) IS
7: dummy NUMBER;
8: BEGIN
9: SELECT NULL INTO dummy
10: FROM fnd_lookups
11: WHERE lookup_type = typ
12: AND lookup_code = code
13: AND enabled_flag = 'Y'
14: AND ( (start_date_active IS NULL)

Line 74: rv fnd_lookups.lookup_code%TYPE;

70: WHERE meaning = descr
71: AND lookup_type = typ
72: ORDER BY pri;
73: codes_r codes_c%ROWTYPE;
74: rv fnd_lookups.lookup_code%TYPE;
75: BEGIN
76: OPEN codes_c;
77: FETCH codes_c INTO codes_r;
78: IF(codes_c%found) THEN