APPS.ONT_ACTIVITY_SUM_ORDER_PURGE dependencies on FND_CONCURRENT_PROGRAMS

Line 17: FROM fnd_concurrent_programs

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
18: WHERE concurrent_program_name = 'ORDPUR'
19: AND application_id = 660)
20: AND requested_by = FND_GLOBAL.USER_ID;
21:

Line 40: FROM fnd_concurrent_programs

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
41: WHERE concurrent_program_name = 'ORDPUR'
42: AND application_id = 660);
43:
44: -- Insert this name, value pair in summarizer table by using summarizer API 'insert_row'

Line 83: FROM fnd_concurrent_programs

79: WHERE phase_code = 'C'
80: AND program_application_id = 660
81: AND concurrent_program_id =
82: (SELECT concurrent_program_id
83: FROM fnd_concurrent_programs
84: WHERE concurrent_program_name = 'ORDPUR'
85: AND application_id = 660));
86:
87:

Line 119: FROM fnd_concurrent_programs

115: FROM fnd_tm_events
116: WHERE TIMESTAMP < SYSDATE - 1
117: AND (program_application_id, concurrent_program_id) IN
118: (SELECT application_id, concurrent_program_id
119: FROM fnd_concurrent_programs
120: WHERE concurrent_program_name = 'ORDPUR'
121: AND application_id = 660);
122:
123: