APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_LOOKUP_VALUES

Line 53: l_meaning igs_lookup_values.meaning%TYPE;

49: (reverse chronological order - newest change first)
50: asbala 13-OCT-2003 Bug 3130316. Import Process Logging Framework Related changes.
51: asbala 21-OCT-2003 Bug 3130316. Import Process - New logic to delete completed records.
52: ***************************************************************/
53: l_meaning igs_lookup_values.meaning%TYPE;
54: l_count NUMBER;
55: l_count1 NUMBER;
56: l_count2 NUMBER;
57: l_count3 NUMBER;

Line 69: CURSOR meaning_cur(cp_lookup_code igs_lookup_values.lookup_code%TYPE,

65: l_industry VARCHAR2(5);
66: l_schema VARCHAR2(30);
67: l_return BOOLEAN;
68:
69: CURSOR meaning_cur(cp_lookup_code igs_lookup_values.lookup_code%TYPE,
70: cp_lookup_type igs_lookup_values.lookup_type%TYPE)
71: IS
72: SELECT meaning
73: FROM igs_lookup_values

Line 70: cp_lookup_type igs_lookup_values.lookup_type%TYPE)

66: l_schema VARCHAR2(30);
67: l_return BOOLEAN;
68:
69: CURSOR meaning_cur(cp_lookup_code igs_lookup_values.lookup_code%TYPE,
70: cp_lookup_type igs_lookup_values.lookup_type%TYPE)
71: IS
72: SELECT meaning
73: FROM igs_lookup_values
74: WHERE lookup_type = cp_lookup_type AND

Line 73: FROM igs_lookup_values

69: CURSOR meaning_cur(cp_lookup_code igs_lookup_values.lookup_code%TYPE,
70: cp_lookup_type igs_lookup_values.lookup_type%TYPE)
71: IS
72: SELECT meaning
73: FROM igs_lookup_values
74: WHERE lookup_type = cp_lookup_type AND
75: lookup_code = cp_lookup_code;
76:
77: BEGIN