APPS.FND_CONC_REQUEST_PKG dependencies on FND_LOOKUPS

Line 178: from fnd_lookups ph

174: exception
175: when no_data_found then
176: /*changed query for BUG#5007915 SQLID#14602738 */
177: select ph.meaning into phase
178: from fnd_lookups ph
179: where ph.lookup_type = PHASE_LOOKUP_TYPE
180: and ph.lookup_code = upcode;
181:
182: select st.meaning into status

Line 183: from fnd_lookups st

179: where ph.lookup_type = PHASE_LOOKUP_TYPE
180: and ph.lookup_code = upcode;
181:
182: select st.meaning into status
183: from fnd_lookups st
184: where st.lookup_type = STATUS_LOOKUP_TYPE
185: and st.lookup_code = uscode;
186: end get_phase_status;
187:

Line 192: upcode fnd_lookups.lookup_code%TYPE;

188:
189: function get_user_phase_code (phase in varchar2)
190: return varchar2 is
191:
192: upcode fnd_lookups.lookup_code%TYPE;
193:
194: begin
195: if (phase is null) then
196: return (NULL);

Line 201: from fnd_lookups

197: end if;
198:
199: select lookup_code
200: into upcode
201: from fnd_lookups
202: where lookup_type = PHASE_LOOKUP_TYPE
203: and meaning like phase
204: order by lookup_code;
205:

Line 217: uscode fnd_lookups.lookup_code%TYPE;

213:
214: function get_user_status_code (status in varchar2)
215: return varchar2 is
216:
217: uscode fnd_lookups.lookup_code%TYPE;
218:
219: begin
220: if (status is null) then
221: return (NULL);

Line 226: from fnd_lookups

222: end if;
223:
224: select lookup_code
225: into uscode
226: from fnd_lookups
227: where lookup_type = STATUS_LOOKUP_TYPE
228: and meaning like status
229: order by lookup_code;
230: