DBA Data[Home] [Help]

APPS.FND_CP_OPP_REQ dependencies on FND_CONCURRENT_PROGRAMS

Line 27: fnd_concurrent_programs fcp, fnd_application a

23:
24: select fcp.concurrent_program_name, a.application_short_name
25: into prog_name, appl_name
26: from fnd_concurrent_requests fcr,
27: fnd_concurrent_programs fcp, fnd_application a
28: where fcr.request_id = reqid
29: and fcp.concurrent_program_id = fcr.concurrent_program_id
30: and fcp.application_id = fcr.program_application_id
31: and fcp.application_id = a.application_id

Line 542: fnd_concurrent_programs fcp, fnd_application a

538:
539: select fcp.concurrent_program_name, a.application_short_name, argument1
540: into prog_name, appl_name, parent_req_id
541: from fnd_concurrent_requests fcr,
542: fnd_concurrent_programs fcp, fnd_application a
543: where fcr.request_id = reqid
544: and fcp.concurrent_program_id = fcr.concurrent_program_id
545: and fcp.application_id = fcr.program_application_id
546: and fcp.application_id = a.application_id