APPS.OKL_BILLING_CONTROLLER_PVT dependencies on FND_CONCURRENT_PROGRAMS_VL

Line 160: fnd_concurrent_programs_vl pgm

156: -- --------------------------------------
157: CURSOR cnt_csr (p_conc_pgm1 VARCHAR2, p_conc_pgm2 VARCHAR2) IS
158: select count(*)
159: from fnd_concurrent_requests req,
160: fnd_concurrent_programs_vl pgm
161: where pgm.USER_CONCURRENT_PROGRAM_NAME
162: IN ( p_conc_pgm1, p_conc_pgm2)
163: and req.concurrent_program_id = pgm.concurrent_program_id
164: and req.PHASE_CODE <> 'C';

Line 261: fnd_concurrent_programs_vl pgm

257: and org_id = l_org_id
258: and request_id in (
259: select req.request_id
260: from fnd_concurrent_requests req,
261: fnd_concurrent_programs_vl pgm
262: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Process Billable Streams',
263: 'Process Billable Streams')
264: and req.concurrent_program_id = pgm.concurrent_program_id
265: and req.PHASE_CODE = 'C');

Line 314: fnd_concurrent_programs_vl pgm

310: and org_id = l_org_id
311: and request_id in (
312: select req.request_id
313: from fnd_concurrent_requests req,
314: fnd_concurrent_programs_vl pgm
315: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Bills Consolidation',
316: 'Receivables Bills Consolidation')
317: and req.concurrent_program_id = pgm.concurrent_program_id
318: and req.PHASE_CODE = 'C');

Line 365: fnd_concurrent_programs_vl pgm

361: and org_id = l_org_id
362: and request_id in (
363: select req.request_id
364: from fnd_concurrent_requests req,
365: fnd_concurrent_programs_vl pgm
366: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Invoice Transfer',
367: 'Receivables Invoice Transfer to AR')
368: and req.concurrent_program_id = pgm.concurrent_program_id
369: and req.PHASE_CODE = 'C');

Line 418: fnd_concurrent_programs_vl pgm

414: AND org_id = l_org_id
415: AND request_id IN (
416: SELECT req.request_id
417: FROM fnd_concurrent_requests req,
418: fnd_concurrent_programs_vl pgm
419: WHERE pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Prepare Receivables',
420: 'Prepare Receivables Bills')
421: AND req.concurrent_program_id = pgm.concurrent_program_id
422: AND req.PHASE_CODE = 'C');

Line 475: fnd_concurrent_programs_vl pgm

471: and org_id = l_org_id
472: and request_id in (
473: select req.request_id
474: from fnd_concurrent_requests req,
475: fnd_concurrent_programs_vl pgm
476: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Process Billable Streams',
477: 'Process Billable Streams')
478: and req.concurrent_program_id = pgm.concurrent_program_id
479: and req.PHASE_CODE = 'C');

Line 527: fnd_concurrent_programs_vl pgm

523: and org_id = l_org_id
524: and request_id in (
525: select req.request_id
526: from fnd_concurrent_requests req,
527: fnd_concurrent_programs_vl pgm
528: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Bills Consolidation',
529: 'Receivables Bills Consolidation')
530: and req.concurrent_program_id = pgm.concurrent_program_id
531: and req.PHASE_CODE = 'C');

Line 580: fnd_concurrent_programs_vl pgm

576: and org_id = l_org_id
577: and request_id in (
578: select req.request_id
579: from fnd_concurrent_requests req,
580: fnd_concurrent_programs_vl pgm
581: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Invoice Transfer',
582: 'Receivables Invoice Transfer to AR')
583: and req.concurrent_program_id = pgm.concurrent_program_id
584: and req.PHASE_CODE = 'C');

Line 638: fnd_concurrent_programs_vl pgm

634: AND org_id = l_org_id
635: AND request_id IN (
636: SELECT req.request_id
637: FROM fnd_concurrent_requests req,
638: fnd_concurrent_programs_vl pgm
639: WHERE pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Prepare Receivables',
640: 'Prepare Receivables Bills')
641: AND req.concurrent_program_id = pgm.concurrent_program_id
642: AND req.PHASE_CODE = 'C');