APPS.IGR_IMP_004 dependencies on IGS_LOOKUPS_VIEW

Line 82: lv_meaning igs_lookups_view.meaning%TYPE;

78: Who When What
79:
80: *******************************************************************************/
81: -------------------------Variable Declaration------------------------------------
82: lv_meaning igs_lookups_view.meaning%TYPE;
83: -------------------------End Variable Declaration------------------------------------
84:
85: ---------------------------Cursor Declarations----------------------------------------
86: -- Cursor c_lkup is used to select the record (if any) that matches the

Line 88: CURSOR c_lkup (cp_lookup_type IGS_LOOKUPS_VIEW.LOOKUP_TYPE%TYPE,

84:
85: ---------------------------Cursor Declarations----------------------------------------
86: -- Cursor c_lkup is used to select the record (if any) that matches the
87: -- criteria passed via the parameters to the fucntion
88: CURSOR c_lkup (cp_lookup_type IGS_LOOKUPS_VIEW.LOOKUP_TYPE%TYPE,
89: cp_lookup_code IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
90: SELECT meaning
91: FROM igs_lookups_view
92: WHERE lookup_type = cp_lookup_type

Line 89: cp_lookup_code IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS

85: ---------------------------Cursor Declarations----------------------------------------
86: -- Cursor c_lkup is used to select the record (if any) that matches the
87: -- criteria passed via the parameters to the fucntion
88: CURSOR c_lkup (cp_lookup_type IGS_LOOKUPS_VIEW.LOOKUP_TYPE%TYPE,
89: cp_lookup_code IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
90: SELECT meaning
91: FROM igs_lookups_view
92: WHERE lookup_type = cp_lookup_type
93: AND lookup_code = cp_lookup_code;

Line 91: FROM igs_lookups_view

87: -- criteria passed via the parameters to the fucntion
88: CURSOR c_lkup (cp_lookup_type IGS_LOOKUPS_VIEW.LOOKUP_TYPE%TYPE,
89: cp_lookup_code IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
90: SELECT meaning
91: FROM igs_lookups_view
92: WHERE lookup_type = cp_lookup_type
93: AND lookup_code = cp_lookup_code;
94: ---------------------------End Cursor Declarations----------------------------------------
95: BEGIN