APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_REQUEST_SET_OBJECTS

Line 977: bis_request_set_objects a,

973:
974: cursor c_obj_direct_in_set (P_REQSET_ID NUMBER) is
975: select distinct a.object_name, a.object_type,a.object_owner
976: from
977: bis_request_set_objects a,
978: fnd_request_sets b,
979: fnd_concurrent_requests c
980: where a.request_set_name=b.request_set_name
981: and a.SET_APP_ID=b.application_id

Line 1193: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_CONCURRENT_REQUESTS FND

1189: l_return_flag VARCHAR2(1);
1190: l_start_time DATE;
1191: CURSOR c_dashboards_rs IS
1192: SELECT 'Y', START_DATE
1193: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_CONCURRENT_REQUESTS FND
1194: WHERE OBJECTS.object_name = p_obj_name
1195: AND OBJECTS.object_type = p_obj_type
1196: AND BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> 'ANAL'
1197: AND OBJECTS.request_set_name = HISTORY.request_set_name

Line 1207: FROM bis_request_set_objects

1203: CURSOR c_reports_rs IS
1204: SELECT 'Y', START_DATE
1205: FROM (
1206: SELECT request_set_name --request set for dashboard that has this report
1207: FROM bis_request_set_objects
1208: WHERE object_name IN (
1209: SELECT DISTINCT obj.OBJECT_NAME
1210: FROM bis_obj_dependency obj
1211: WHERE object_type IN ('PAGE') AND enabled_flag='Y'

Line 1220: FROM bis_request_set_objects

1216: )
1217: AND object_type ='PAGE'
1218: UNION -- request set for report directly
1219: SELECT request_set_name
1220: FROM bis_request_set_objects
1221: WHERE object_name = p_obj_name
1222: AND object_type IN ('REPORT','PORTLET')
1223: ) RS, BIS_RS_RUN_HISTORY HISTORY, FND_CONCURRENT_REQUESTS FND
1224: WHERE BIS_BIA_RSG_PSTATE.get_refresh_mode(RS.REQUEST_SET_NAME) <> 'ANAL'