APPS.CAC_TASK_PURGE_PVT dependencies on FND_CONCURRENT_PROGRAMS

Line 34: | fnd_concurrent_programs_U1,instead|

30: | Added code to delete record |
31: | record from JTF_TASK_PHONE table |
32: | for Bug # 5216358. |
33: | 30-May-2006 Swapan Barat For bug# 5213367. Using index |
34: | fnd_concurrent_programs_U1,instead|
35: | of fnd_concurrent_programs_U2 |
36: | 13-Jul-2006 Swapan Barat Checking template_flag <> 'Y' |
37: | before removing records from |
38: | JTF_TASK_DEPENDS for bug# 5388975 |

Line 35: | of fnd_concurrent_programs_U2 |

31: | record from JTF_TASK_PHONE table |
32: | for Bug # 5216358. |
33: | 30-May-2006 Swapan Barat For bug# 5213367. Using index |
34: | fnd_concurrent_programs_U1,instead|
35: | of fnd_concurrent_programs_U2 |
36: | 13-Jul-2006 Swapan Barat Checking template_flag <> 'Y' |
37: | before removing records from |
38: | JTF_TASK_DEPENDS for bug# 5388975 |
39: +======================================================================*/

Line 229: (Select /*+ INDEX(p fnd_concurrent_programs_U1) */ r.request_id

225: -- Modified by SBARAT on 30/05/2006 for bug# 5213367
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

Line 231: fnd_concurrent_programs p

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');
235: