APPS.BIS_BIA_REFRESH_REPORT dependencies on FND_REQUEST_SETS_VL

Line 64: fnd_request_sets_vl s,

60: RANK () OVER (PARTITION BY s.request_set_id ORDER BY c.actual_completion_date DESC)
61: pos,
62: v.meaning
63: FROM bis_request_set_objects_v o,
64: fnd_request_sets_vl s,
65: fnd_concurrent_requests c,
66: fnd_concurrent_programs p,
67: fnd_user u,
68: bis_request_set_options r,

Line 105: l_request_set_id fnd_request_sets_vl.request_set_id%TYPE;

101: IS
102: sql_str VARCHAR2 (2000);
103: vorderby VARCHAR2 (200);
104: l_request_id fnd_concurrent_requests.request_id%TYPE;
105: l_request_set_id fnd_request_sets_vl.request_set_id%TYPE;
106: l_request_set_name fnd_request_sets_vl.request_set_name%TYPE;
107: l_user_request_set_name fnd_request_sets_vl.user_request_set_name%TYPE;
108: BEGIN
109: FOR i IN 1 .. p_page_parameter_tbl.COUNT

Line 106: l_request_set_name fnd_request_sets_vl.request_set_name%TYPE;

102: sql_str VARCHAR2 (2000);
103: vorderby VARCHAR2 (200);
104: l_request_id fnd_concurrent_requests.request_id%TYPE;
105: l_request_set_id fnd_request_sets_vl.request_set_id%TYPE;
106: l_request_set_name fnd_request_sets_vl.request_set_name%TYPE;
107: l_user_request_set_name fnd_request_sets_vl.user_request_set_name%TYPE;
108: BEGIN
109: FOR i IN 1 .. p_page_parameter_tbl.COUNT
110: LOOP

Line 107: l_user_request_set_name fnd_request_sets_vl.user_request_set_name%TYPE;

103: vorderby VARCHAR2 (200);
104: l_request_id fnd_concurrent_requests.request_id%TYPE;
105: l_request_set_id fnd_request_sets_vl.request_set_id%TYPE;
106: l_request_set_name fnd_request_sets_vl.request_set_name%TYPE;
107: l_user_request_set_name fnd_request_sets_vl.user_request_set_name%TYPE;
108: BEGIN
109: FOR i IN 1 .. p_page_parameter_tbl.COUNT
110: LOOP
111: IF p_page_parameter_tbl (i).parameter_name = 'REQUEST_SET_ID'