301: -- end if;
302:
303: ltype := 'CP_PHASE_CODE';
304: select meaning into req_phase
305: from fnd_lookups
306: where lookup_code = upcode
307: and lookup_type = ltype;
308:
309: -- Bug 7021067. Support all the request statues
319: req_status_code := uscode;
320:
321: ltype := 'CP_STATUS_CODE';
322: select meaning into req_status
323: from fnd_lookups
324: where lookup_code = req_status_code
325: and lookup_type = ltype;
326:
327: end get_phase_and_status;