APPS.CTO_WORKFLOW_API_PK dependencies on FND_CONCURRENT_PROGRAMS

Line 139: | There was a full table scan on fnd_concurrent_programs

135: | from display_wf_status
136: |
137: |
138: | 11/19/2003 Kiran Konada
139: | There was a full table scan on fnd_concurrent_programs
140: | hece, added where clause
141: | and application_id = 702;BOM , bugfix 2885568
142: |
143: | original query

Line 146: from fnd_concurrent_programs a

142: |
143: | original query
144: | select concurrent_program_id
145: into p_program_id
146: from fnd_concurrent_programs a
147: where concurrent_program_name = 'CTOACREQ'
148: |
149: |
150: | new query

Line 153: | from fnd_concurrent_programs a

149: |
150: | new query
151: | select concurrent_program_id
152: | into p_program_id
153: | from fnd_concurrent_programs a
154: | where concurrent_program_name = 'CTOACREQ'
155: | and application_id = 702
156: |
157: |

Line 2985: from fnd_concurrent_programs a

2981: -- check if the line has/is beeing processed by the Concurrent Request.
2982: --
2983: select concurrent_program_id
2984: into p_program_id
2985: from fnd_concurrent_programs a
2986: where concurrent_program_name = 'CTOACREQ'
2987: and application_id = 702; --BOM , bugfix 2885568 for
2988: --full table scan
2989: