APPS.FND_CONC_REQUEST_PKG dependencies on FND_LOOKUPS

Line 225: from fnd_lookups ph

221:
222: when no_data_found then
223: /*changed query for BUG#5007915 SQLID#14602738 */
224: select ph.meaning into phase
225: from fnd_lookups ph
226: where ph.lookup_type = PHASE_LOOKUP_TYPE
227: and ph.lookup_code = upcode;
228:
229: select st.meaning into status

Line 230: from fnd_lookups st

226: where ph.lookup_type = PHASE_LOOKUP_TYPE
227: and ph.lookup_code = upcode;
228:
229: select st.meaning into status
230: from fnd_lookups st
231: where st.lookup_type = STATUS_LOOKUP_TYPE
232: and st.lookup_code = uscode;
233: end get_phase_status;
234:

Line 239: upcode fnd_lookups.lookup_code%TYPE;

235:
236: function get_user_phase_code (phase in varchar2)
237: return varchar2 is
238:
239: upcode fnd_lookups.lookup_code%TYPE;
240:
241: begin
242: if (phase is null) then
243: return (NULL);

Line 248: from fnd_lookups

244: end if;
245:
246: select lookup_code
247: into upcode
248: from fnd_lookups
249: where lookup_type = PHASE_LOOKUP_TYPE
250: and meaning like phase
251: order by lookup_code;
252:

Line 264: uscode fnd_lookups.lookup_code%TYPE;

260:
261: function get_user_status_code (status in varchar2)
262: return varchar2 is
263:
264: uscode fnd_lookups.lookup_code%TYPE;
265:
266: begin
267: if (status is null) then
268: return (NULL);

Line 273: from fnd_lookups

269: end if;
270:
271: select lookup_code
272: into uscode
273: from fnd_lookups
274: where lookup_type = STATUS_LOOKUP_TYPE
275: and meaning like status
276: order by lookup_code;
277: