APPS.FND_REQUEST_SET dependencies on FND_REQUEST_SET_STAGES

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 154: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages

150: begin
151: select REQUEST_DATE into req_request_date from FND_CONCURRENT_REQUESTS where REQUEST_ID = conc_req_id;
152: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS sets
153: where REQUEST_SET_ID = set_id AND application_id = appl_id;
154: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages
155: WHERE request_set_id = set_id
156: AND SET_APPLICATION_ID = appl_id;
157: IF( tmpDate > rset_last_updated_date) THEN
158: rset_last_updated_date := tmpDate;

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

Line 566: from fnd_request_set_stages s, fnd_executables e

562: s.function_id, s.function_application_id
563: into hardwired_outcome, funct,
564: g_set_appl_id, g_set_id, g_stage_id,
565: g_function_id, g_function_appl_id
566: from fnd_request_set_stages s, fnd_executables e
567: where s.set_application_id = appl_id
568: and s.request_set_id = set_id
569: and s.request_set_stage_id = stage_id
570: and e.executable_id(+) = s.function_id