APPS.HR_FR_SEED_PKG dependencies on FND_COMMON_LOOKUPS

Line 292: v_lookup_code fnd_common_lookups.lookup_code%TYPE;

288: P_LOOKUP_TYPE IN varchar2,
289: P_USER_COLUMN_NAME IN varchar2,
290: P_USER_KEY_UNITS IN varchar2)
291: IS
292: v_lookup_code fnd_common_lookups.lookup_code%TYPE;
293: v_meaning fnd_common_lookups.meaning%TYPE;
294:
295: v_sequence number := 10;
296:

Line 293: v_meaning fnd_common_lookups.meaning%TYPE;

289: P_USER_COLUMN_NAME IN varchar2,
290: P_USER_KEY_UNITS IN varchar2)
291: IS
292: v_lookup_code fnd_common_lookups.lookup_code%TYPE;
293: v_meaning fnd_common_lookups.meaning%TYPE;
294:
295: v_sequence number := 10;
296:
297: v_legislation_code varchar2 (10) := NULL; -- holds legislation code returned

Line 301: FROM fnd_common_lookups

297: v_legislation_code varchar2 (10) := NULL; -- holds legislation code returned
298:
299: CURSOR lookup_code_csr IS
300: SELECT lookup_code, meaning
301: FROM fnd_common_lookups
302: WHERE lookup_type = P_LOOKUP_TYPE;
303:
304: BEGIN
305: hr_utility.trace ('PROCEDURE create_from_lookup entered.');