APPS.IGS_PE_SET_REM_HOLDS dependencies on IGS_LOOKUPS_VIEW

Line 49: CURSOR c_desc( x_type igs_lookups_view.lookup_type%TYPE , x_code igs_lookups_view.lookup_code%TYPE ) IS

45: --Change History:
46: --Who When What
47: -------------------------------------------------------------------
48:
49: CURSOR c_desc( x_type igs_lookups_view.lookup_type%TYPE , x_code igs_lookups_view.lookup_code%TYPE ) IS
50: SELECT meaning
51: FROM igs_lookups_view
52: WHERE lookup_code = x_code
53: AND lookup_type = x_type ;

Line 51: FROM igs_lookups_view

47: -------------------------------------------------------------------
48:
49: CURSOR c_desc( x_type igs_lookups_view.lookup_type%TYPE , x_code igs_lookups_view.lookup_code%TYPE ) IS
50: SELECT meaning
51: FROM igs_lookups_view
52: WHERE lookup_code = x_code
53: AND lookup_type = x_type ;
54:
55: l_desc igs_lookups_view.meaning%TYPE ;

Line 55: l_desc igs_lookups_view.meaning%TYPE ;

51: FROM igs_lookups_view
52: WHERE lookup_code = x_code
53: AND lookup_type = x_type ;
54:
55: l_desc igs_lookups_view.meaning%TYPE ;
56:
57: BEGIN
58:
59: IF l_code IS NULL THEN