DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on FND_CONCURRENT_REQUESTS

Line 822: from fnd_concurrent_requests a

818:
819: function get_root_req_id(p_prog_request_id number) return number is
820: cursor c_root_req_id is
821: select a.priority_request_id
822: from fnd_concurrent_requests a
823: where a.request_id =
824: (select b.parent_request_id from fnd_concurrent_requests b where b.request_id=p_prog_request_id );
825: l_root_req_id number;
826: begin

Line 824: (select b.parent_request_id from fnd_concurrent_requests b where b.request_id=p_prog_request_id );

820: cursor c_root_req_id is
821: select a.priority_request_id
822: from fnd_concurrent_requests a
823: where a.request_id =
824: (select b.parent_request_id from fnd_concurrent_requests b where b.request_id=p_prog_request_id );
825: l_root_req_id number;
826: begin
827: open c_root_req_id;
828: fetch c_root_req_id into l_root_req_id;