APPS.FND_REQUEST_SET dependencies on FND_REQUEST_SET_STAGES_VL

Line 113: fnd_request_set_stages_vl stages

109: begin
110: select request_set_stage_id, request_set_stage_id, user_stage_name
111: into stage_id, next_stage, request_desc
112: from fnd_request_sets sets,
113: fnd_request_set_stages_vl stages
114: where sets.application_id = appl_id
115: and sets.request_set_id = set_id
116: and stages.set_application_id = sets.application_id
117: and stages.request_set_id = sets.request_set_id

Line 213: from fnd_request_set_stages_vl stages

209: stage_id := error_stage_id;
210: error_stage_id := null;
211: select request_set_stage_id, user_stage_name
212: into next_stage, request_desc
213: from fnd_request_set_stages_vl stages
214: where stages.set_application_id = appl_id
215: and stages.request_set_id = set_id
216: and stages.request_set_stage_id = stage_id;
217: exception

Line 245: from fnd_request_set_stages_vl

241: /* Get Next Stage and Critical info*/
242: begin
243: select decode(current_outcome, 'S', success_link, 'W', warning_link, error_link), critical, user_stage_name
244: into next_stage, is_critical, user_stage_name
245: from fnd_request_set_stages_vl
246: where request_set_id = set_id
247: and set_application_id = appl_id
248: and request_set_stage_id = stage_id;
249: exception

Line 321: from fnd_request_set_stages_vl

317: /* Get next stage */
318: begin
319: Select user_stage_name
320: into request_desc
321: from fnd_request_set_stages_vl
322: where request_set_id = set_id
323: and set_application_id = appl_id
324: and request_set_stage_id = next_stage;
325: exception