APPS.OTAFRUDT dependencies on FND_COMMON_LOOKUPS

Line 287: v_lookup_code fnd_common_lookups.lookup_code%TYPE;

283: P_LOOKUP_TYPE IN varchar2,
284: P_USER_COLUMN_NAME IN varchar2,
285: P_USER_KEY_UNITS IN varchar2)
286: IS
287: v_lookup_code fnd_common_lookups.lookup_code%TYPE;
288: v_meaning fnd_common_lookups.meaning%TYPE;
289:
290: v_sequence number := 10;
291:

Line 288: v_meaning fnd_common_lookups.meaning%TYPE;

284: P_USER_COLUMN_NAME IN varchar2,
285: P_USER_KEY_UNITS IN varchar2)
286: IS
287: v_lookup_code fnd_common_lookups.lookup_code%TYPE;
288: v_meaning fnd_common_lookups.meaning%TYPE;
289:
290: v_sequence number := 10;
291:
292: v_legislation_code varchar2 (10) := NULL; -- holds legislation code returned

Line 296: FROM fnd_common_lookups

292: v_legislation_code varchar2 (10) := NULL; -- holds legislation code returned
293:
294: CURSOR lookup_code_csr IS
295: SELECT lookup_code, meaning
296: FROM fnd_common_lookups
297: WHERE lookup_type = P_LOOKUP_TYPE;
298:
299: BEGIN
300: hr_utility.trace ('PROCEDURE create_from_lookup entered.');