APPS.PJI_LAUNCH_UPP_MAIN dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 408: from pji_pjp_proj_batch_map a,

404: --bug 7121511 start
405: update pji_prg_group c set c.batch_name = c.batch_name||'-ERR'
406: where c.prg_group in
407: ( select distinct b.prg_group
408: from pji_pjp_proj_batch_map a,
409: pji_prg_group b
410: where a.project_id = b.project_id
411: and b.prg_group is not null
412: );

Line 417: from pji_pjp_proj_batch_map a,

413:
414: update pji_prg_group c set c.batch_name = c.batch_name||'-ERR'
415: where c.project_id in
416: ( select distinct b.project_id
417: from pji_pjp_proj_batch_map a,
418: pji_prg_group b
419: where a.project_id = b.project_id
420: and b.prg_group is null
421: );

Line 439: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,

435: -- bug 6276970 & 6505683
436: -- Sridhar Added below insert and update statement
437:
438: update pji_prg_group c set c.batch_name = ( select d1.value
439: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,
440: pji_prg_group b1
441: where a1.project_id = b1.project_id
442: and c.batch_name like '%-ERR'
443: and b1.prg_group = c.prg_group

Line 453: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,

449: where
450: c.batch_name like '%-ERR'
451: and exists
452: ( select 'x'
453: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,
454: pji_prg_group b2
455: where a2.project_id = b2.project_id
456: and b2.prg_group = c.prg_group
457: and to_number(substr(d2.name,8,instr(d2.name,'$',1) - 8)) = a2.worker_id -- Sridhar changed added substr june-11th V1_CHANGE

Line 465: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,

461:
462: -- Sridhar changed june-11th Added new Update Statement START V1_CHANGE
463:
464: update pji_prg_group c set c.batch_name = ( select d1.value
465: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,
466: pji_prg_group b1
467: where a1.project_id = b1.project_id
468: and c.batch_name like '%-ERR'
469: and b1.project_id = c.project_id

Line 479: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,

475: where
476: c.batch_name like '%-ERR'
477: and exists
478: ( select 'x'
479: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,
480: pji_prg_group b2
481: where a2.project_id = b2.project_id
482: and b2.project_id = c.project_id
483: and to_number(substr(d2.name,8,instr(d2.name,'$',1) - 8)) = a2.worker_id

Line 2701: PJI_PJP_PROJ_BATCH_MAP map1 ,

2697: nvl(ver.PRG_GROUP,-1) ,
2698: map1.project_id project_id ,
2699: nvl(ver.prg_level,-1)
2700: FROM
2701: PJI_PJP_PROJ_BATCH_MAP map1 ,
2702: PA_PROJ_ELEMENT_VERSIONS ver
2703: WHERE
2704: ver.object_type = 'PA_STRUCTURES' AND
2705: ver.project_id = map1.project_id ;