APPS.CAC_TASK_PURGE_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 110: Select request_id From FND_CONCURRENT_REQUESTS

106: l_main_conc_req_message VARCHAR2(512);
107: l_child_message VARCHAR2(4000);
108:
109: Cursor C_Child_Request(p_request_id NUMBER) Is
110: Select request_id From FND_CONCURRENT_REQUESTS
111: Where parent_request_id = p_request_id;
112:
113: TYPE C_Cur_Type IS REF CURSOR;
114: C_Cur_Ref C_Cur_Type;

Line 230: From fnd_concurrent_requests r ,

226:
227: Delete JTF_TASK_PURGE
228: Where concurrent_request_id In
229: (Select /*+ INDEX(p fnd_concurrent_programs_U1) */ r.request_id
230: From fnd_concurrent_requests r ,
231: fnd_concurrent_programs p
232: Where r.phase_code = 'C'
233: And p.concurrent_program_id = r.concurrent_program_id
234: And p.concurrent_program_name = 'CACTKPUR');