180: || agairola 11-Mar-2003 Bug 2838757: Initialized g_b_data_found
181: || to false
182: || (reverse chronological order - newest change first)
183: ******************************************************************/
184: CURSOR c_lkp(cp_lookup_type ap_lookup_codes.lookup_type%TYPE,
185: cp_lookup_code ap_lookup_codes.lookup_code%TYPE) IS
186: SELECT displayed_field
187: FROM ap_lookup_codes
188: WHERE lookup_type = cp_lookup_type
181: || to false
182: || (reverse chronological order - newest change first)
183: ******************************************************************/
184: CURSOR c_lkp(cp_lookup_type ap_lookup_codes.lookup_type%TYPE,
185: cp_lookup_code ap_lookup_codes.lookup_code%TYPE) IS
186: SELECT displayed_field
187: FROM ap_lookup_codes
188: WHERE lookup_type = cp_lookup_type
189: AND lookup_code = cp_lookup_code;
183: ******************************************************************/
184: CURSOR c_lkp(cp_lookup_type ap_lookup_codes.lookup_type%TYPE,
185: cp_lookup_code ap_lookup_codes.lookup_code%TYPE) IS
186: SELECT displayed_field
187: FROM ap_lookup_codes
188: WHERE lookup_type = cp_lookup_type
189: AND lookup_code = cp_lookup_code;
190: BEGIN
191: