APPS.FND_REQUEST_SET_STAGES_PKG dependencies on FND_REQUEST_SET_STAGES_VL

Line 341: FROM fnd_request_set_stages_vl WHERE (success_link = bad_stage_id)

337:
338: bad_link_counter BINARY_INTEGER := 0;
339:
340: CURSOR get_bad_links IS SELECT set_application_id, request_set_id, request_set_stage_id
341: FROM fnd_request_set_stages_vl WHERE (success_link = bad_stage_id)
342: OR (warning_link = bad_stage_id)
343: OR (error_link = bad_stage_id);
344:
345: --BUG 871226 (End of Added Declarations)

Line 364: FROM fnd_request_set_stages_vl

360:
361: --BUG 871226 (Begin of Added Code)
362:
363: SELECT request_set_stage_id INTO bad_stage_id
364: FROM fnd_request_set_stages_vl
365: WHERE set_application_id = x_set_application_id
366: AND request_set_id = x_request_set_id
367: AND request_set_stage_id = x_request_set_stage_id;
368:

Line 386: FROM fnd_request_set_stages_vl WHERE

382:
383: FOR array_index IN 0..bad_link_counter - 1 LOOP -- dec 1 from counter because too high
384:
385: SELECT success_link,warning_link,error_link INTO bad_SL,bad_WL,bad_EL
386: FROM fnd_request_set_stages_vl WHERE
387: set_application_id = set_app_id_array(array_index) AND
388: request_set_id = req_set_id_array(array_index) AND
389: request_set_stage_id = req_set_stage_id_array(array_index);
390: