DBA Data[Home] [Help]

APPS.CSP_MIN_MAX_PLANNING dependencies on FND_CONCURRENT_PROGRAMS

Line 101: from fnd_concurrent_requests fcr,fnd_concurrent_programs fcp

97: --and status_id = 1; /* Fix for R12 same as 115.10 bug 4960060 */
98:
99: Cursor c_parent_request is
100: select max(request_id)
101: from fnd_concurrent_requests fcr,fnd_concurrent_programs fcp
102: where fcr.program_application_id = fcp.application_id
103: and fcr.concurrent_program_id = fcp.concurrent_program_id
104: and fcp.application_id = 523
105: and fcp.concurrent_program_name = 'CSPPLMMX'

Line 112: fnd_concurrent_programs fcp

108:
109: cursor c_done is
110: select 'x'
111: from fnd_concurrent_requests fcr,
112: fnd_concurrent_programs fcp
113: where fcr.concurrent_program_id = fcp.concurrent_program_id
114: and fcr.program_application_id = fcp.application_id
115: and fcp.application_id = 401
116: and fcp.concurrent_program_name = 'INVISMMX'