DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_XBS_DENORM

Line 1401: , Pa_XBS_DENORM den

1397: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1398: FROM -- pji_pjp_wbs_header hd2
1399: -- pa_proj_elem_ver_structure hd2
1400: pji_pa_proj_events_log ev
1401: , Pa_XBS_DENORM den
1402: , pji_pjp_wbs_header hd9 -- SUP
1403: WHERE
1404: den.struct_version_id IS NULL
1405: AND hd9.wbs_version_id = den.sup_id -- struct_version_id

Line 3245: , pa_xbs_denorm den

3241: AND map.project_id = bv.project_id
3242: ) fpo
3243: , pji_pjp_proj_batch_map map
3244: , pji_pjp_wbs_header whsub
3245: , pa_xbs_denorm den
3246: , ( SELECT -3 plan_version_id FROM dual
3247: UNION ALL
3248: SELECT -4 plan_version_id FROM dual ) cbco
3249: WHERE l_PRG_CHANGE_exists = 'Y' /* Added for bug 8708651 */

Line 3768: , pa_xbs_denorm den

3764: AND map.project_id = bv.project_id
3765: ) fpo
3766: , pji_pjp_proj_batch_map map
3767: , pji_pjp_wbs_header whsub
3768: , pa_xbs_denorm den
3769: , ( SELECT -3 plan_version_id FROM dual
3770: UNION ALL
3771: SELECT -4 plan_version_id FROM dual ) cbco
3772: WHERE l_PRG_CHANGE_exists = 'Y' /* Added for bug 8708651 */