79: l_class_stnd c_class_stnd%ROWTYPE;
80:
81:
82: --Cursor to fetch residency status and house status
83: CURSOR c_res_status(cp_lookup_code igs_lookups_view.lookup_code%TYPE,
84: cp_lookup_type igs_lookups_view.lookup_type%TYPE
85: )
86: IS
87: SELECT 'x'
80:
81:
82: --Cursor to fetch residency status and house status
83: CURSOR c_res_status(cp_lookup_code igs_lookups_view.lookup_code%TYPE,
84: cp_lookup_type igs_lookups_view.lookup_type%TYPE
85: )
86: IS
87: SELECT 'x'
88: FROM igs_lookups_view
84: cp_lookup_type igs_lookups_view.lookup_type%TYPE
85: )
86: IS
87: SELECT 'x'
88: FROM igs_lookups_view
89: WHERE lookup_type = cp_lookup_type
90: AND lookup_code = cp_lookup_code
91: AND enabled_flag = 'Y';
92: