DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_ROLLUP_LEVEL_STATUS

Line 403: DELETE FROM pji_rollup_level_status

399: WHERE plan_version_id = p_dest_fp_version_ids(i)
400: AND project_id = l_dest_project_ids(i);
401:
402: FORALL i IN 1..p_dest_fp_version_ids.COUNT
403: DELETE FROM pji_rollup_level_status
404: WHERE plan_version_id = p_dest_fp_version_ids(i);
405:
406: CLEANUP_INTERIM_TABLES; print_time(' 2.3 .. ');
407:

Line 616: DELETE FROM pji_rollup_level_status

612: DELETE FROM PJI_FP_XBS_ACCUM_F
613: WHERE plan_version_id = p_target_plan_ver_id
614: AND project_id = l_dest_project_id;
615:
616: DELETE FROM pji_rollup_level_status
617: WHERE plan_version_id = p_target_plan_ver_id;
618:
619: CLEANUP_INTERIM_TABLES;
620: print_time(' 1.9 .. ');

Line 8821: , pji_rollup_level_status smart

8817: , g_default_prg_level
8818: , fact1.plan_type_code /* 4471527 */
8819: FROM pji_fp_aggr_pjp1_t fact1
8820: , Pji_RBS_DENORM rbs
8821: , pji_rollup_level_status smart
8822: , pji_pjp_rbs_header rhdr
8823: WHERE 1 = 1
8824: AND fact1.project_id = rhdr.project_id
8825: AND fact1.plan_version_id = rhdr.plan_version_id