DBA Data[Home] [Help]

APPS.PSP_CREATE_EFF_REPORTS dependencies on FND_CONCURRENT_PROGRAMS

Line 215: FROM fnd_concurrent_programs fcp,

211:
212: -- Introduced for bug fix 4182358
213: CURSOR conc_program_name_cur IS
214: SELECT fcp.concurrent_program_name
215: FROM fnd_concurrent_programs fcp,
216: fnd_concurrent_requests fcr
217: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
218: AND fcr.request_id = l_request_id;
219:

Line 220: l_program_name fnd_concurrent_programs.concurrent_program_name%TYPE;

216: fnd_concurrent_requests fcr
217: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
218: AND fcr.request_id = l_request_id;
219:
220: l_program_name fnd_concurrent_programs.concurrent_program_name%TYPE;
221: -- End of bug fix 4182358
222:
223: Cursor HUNDRED_PCENT_EFF_CSR (p_request_id varchar2) is
224: SELECT HUNDRED_PCENT_EFF_AT_PER_ASG, selection_match_level