APPS.BIS_SUBMIT_REQUESTSET dependencies on FND_REQUEST_SETS

Line 838: fnd_request_sets b

834:
835: cursor request_set_option(p_request_set_id varchar2, p_req_set_app_id varchar2) is
836: select distinct a.option_value refresh_mode
837: from bis_request_set_options a,
838: fnd_request_sets b
839: where a.request_set_name=b.request_set_name
840: and a.set_app_id=b.application_id
841: and a.option_name='REFRESH_MODE'
842: and b.request_set_id=p_request_set_id

Line 978: fnd_request_sets b,

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
982: and b.request_set_id=to_number(c.argument2)