APPS.BIS_COLL_RS_HISTORY dependencies on FND_REQUEST_SETS

Line 47: l_req_set_name FND_REQUEST_SETS.REQUEST_SET_NAME%TYPE;

43: is_prog_part_of_rs boolean := false;
44:
45: l_req_set_id number;
46: l_req_app_id number;
47: l_req_set_name FND_REQUEST_SETS.REQUEST_SET_NAME%TYPE;
48:
49:
50: cursor c_stages is
51: select

Line 809: where request_set_name=( select request_set_name from fnd_request_sets

805:
806: cursor refresh_mode is
807: select option_value
808: from bis_request_set_options
809: where request_set_name=( select request_set_name from fnd_request_sets
810: where request_set_id = p_request_set_id
811: and application_id = p_request_set_appl_id)
812: and SET_APP_ID=p_request_set_appl_id
813: and option_name='REFRESH_MODE';

Line 818: where request_set_name=( select request_set_name from fnd_request_sets

814:
815: cursor analyze_object is
816: select option_value
817: from bis_request_set_options
818: where request_set_name=( select request_set_name from fnd_request_sets
819: where request_set_id = p_request_set_id
820: and application_id = p_request_set_appl_id)
821: and SET_APP_ID=p_request_set_appl_id
822: and option_name='ANALYZE_OBJECT';

Line 895: fnd_request_sets

891: and req.argument4 is null;
892:
893: cursor get_rs_details is
894: select request_set_name from
895: fnd_request_sets
896: where application_id = p_request_set_appl_id and request_set_id = p_request_set_id;
897:
898: get_rs_details_rec get_rs_details%rowtype;
899: