DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_ROLLUP_LEVEL_STATUS

Line 401: DELETE FROM pji_rollup_level_status

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

Line 614: DELETE FROM pji_rollup_level_status

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

Line 8673: , pji_rollup_level_status smart

8669: , g_default_prg_level
8670: , fact1.plan_type_code /* 4471527 */
8671: FROM pji_fp_aggr_pjp1_t fact1
8672: , Pji_RBS_DENORM rbs
8673: , pji_rollup_level_status smart
8674: , pji_pjp_rbs_header rhdr
8675: WHERE 1 = 1
8676: AND fact1.project_id = rhdr.project_id
8677: AND fact1.plan_version_id = rhdr.plan_version_id