APPS.FND_REQUEST_SET dependencies on FND_REQUEST_SET_STAGES_VL

Line 112: fnd_request_set_stages_vl stages

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

Line 212: from fnd_request_set_stages_vl stages

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

Line 244: from fnd_request_set_stages_vl

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

Line 323: from fnd_request_set_stages_vl

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