APPS.FND_RT_REQUEST dependencies on FND_CONCURRENT_REQUESTS

Line 18: from fnd_concurrent_requests

14: PROCEDURE search_requests(testid IN INTEGER, timeout IN INTEGER) IS
15:
16: cursor children(parent_id number) is
17: select request_id
18: from fnd_concurrent_requests
19: where parent_request_id <> -1
20: and parent_request_id is not null
21: start with request_id = parent_id
22: connect by prior request_id = parent_request_id;

Line 44: from fnd_concurrent_requests

40: while ((cnt > 0) and (totalsleep < timeout))loop
41: /* the following sleep function is in second */
42: dbms_lock.sleep(60);
43: select count(*) into cnt
44: from fnd_concurrent_requests
45: where phase_code in ('P', 'R')
46: start with request_id = parent.request_id
47: connect by prior request_id = parent_request_id;
48: totalsleep := totalsleep + 1;