DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_XBS_DENORM

Line 1303: , Pa_XBS_DENORM den

1299: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1300: FROM -- pji_pjp_wbs_header hd2
1301: -- pa_proj_elem_ver_structure hd2
1302: pji_pa_proj_events_log ev
1303: , Pa_XBS_DENORM den
1304: , pji_pjp_wbs_header hd9 -- SUP
1305: WHERE
1306: den.struct_version_id IS NULL
1307: AND hd9.wbs_version_id = den.sup_id -- struct_version_id

Line 2638: , pa_xbs_denorm den

2634: AND bv.budget_status_code = 'B' -- Don't care if dangling plan.
2635: AND map.worker_id = g_worker_id
2636: AND map.project_id = bv.project_id
2637: ) fpo
2638: , pa_xbs_denorm den
2639: , pji_pjp_proj_batch_map map
2640: , pji_pjp_wbs_header whsub
2641: , ( SELECT -3 plan_version_id FROM dual
2642: UNION ALL