APPS.ONT_ACTIVITY_SUM_ORDER_PURGE dependencies on FND_CONCURRENT_REQUESTS

Line 8: l_requested_by fnd_concurrent_requests.requested_by%TYPE;

4: PROCEDURE activity_summarizer IS
5:
6: l_count number := 0;
7: l_temp_name varchar2(100);
8: l_requested_by fnd_concurrent_requests.requested_by%TYPE;
9: l_count_logged_user number := 0;
10:
11: CURSOR c_concurrent_request IS
12: SELECT count(*) total

Line 13: FROM fnd_concurrent_requests

9: l_count_logged_user number := 0;
10:
11: CURSOR c_concurrent_request IS
12: SELECT count(*) total
13: FROM fnd_concurrent_requests
14: WHERE phase_code = 'C'
15: AND program_application_id = 660
16: AND concurrent_program_id = (SELECT concurrent_program_id
17: FROM fnd_concurrent_programs

Line 36: FROM fnd_concurrent_requests

32:
33:
34: SELECT count(*)
35: INTO l_count
36: FROM fnd_concurrent_requests
37: WHERE phase_code = 'C'
38: AND program_application_id = 660
39: AND concurrent_program_id = (SELECT concurrent_program_id
40: FROM fnd_concurrent_programs

Line 78: FROM fnd_concurrent_requests

74: FROM fnd_concurrent_processes
75: WHERE process_status_code NOT IN ('A', 'C', 'T', 'M')
76: AND concurrent_process_id IN
77: (SELECT controlling_manager
78: FROM fnd_concurrent_requests
79: WHERE phase_code = 'C'
80: AND program_application_id = 660
81: AND concurrent_program_id =
82: (SELECT concurrent_program_id