APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_FM_EXTR_PLNVER3_T

Line 775: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);

771:
772: IF (p_online_flag = 'Y') THEN
773:
774: /* DELETE FROM pji_rollup_level_status
775: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);
776: Bug No .4538102*/
777:
778: DELETE FROM pji_rollup_level_status
779: WHERE (project_id,plan_version_id,plan_type_code) IN

Line 780: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /*4771527 */

776: Bug No .4538102*/
777:
778: DELETE FROM pji_rollup_level_status
779: WHERE (project_id,plan_version_id,plan_type_code) IN
780: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /*4771527 */
781:
782: IF (SQL%ROWCOUNT > 0) THEN
783:
784: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T', 1 , 1 , 100);

Line 784: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T', 1 , 1 , 100);

780: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /*4771527 */
781:
782: IF (SQL%ROWCOUNT > 0) THEN
783:
784: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T', 1 , 1 , 100);
785:
786: /*
787: FND_STATS.SET_TABLE_STATS(
788: ownname => 'PJI', -- IN VARCHAR2,

Line 789: tabname => 'PJI_FM_EXTR_PLNVER3_T', -- IN VARCHAR2,

785:
786: /*
787: FND_STATS.SET_TABLE_STATS(
788: ownname => 'PJI', -- IN VARCHAR2,
789: tabname => 'PJI_FM_EXTR_PLNVER3_T', -- IN VARCHAR2,
790: numrows => 1, -- IN NUMBER,
791: numblks => 1, -- IN NUMBER,
792: avgrlen => 100 --, -- IN NUMBER,
793: );

Line 798: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t)

794: */
795:
796: DELETE FROM pji_fp_xbs_accum_f
797: WHERE (project_id,plan_version_id,plan_type_code) IN /*4771527 */
798: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t)
799: AND (rbs_aggr_level = 'R'
800: OR (rbs_aggr_level = 'L'
801: AND wbs_rollup_flag = 'Y')) ;
802: g_smart_rows_deleted := SQL%ROWCOUNT;

Line 2791: INSERT INTO PJI_FM_EXTR_PLNVER3_T ver3

2787: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'SECRBS');
2788: print_time(' Populated ver3. ');
2789:
2790:
2791: INSERT INTO PJI_FM_EXTR_PLNVER3_T ver3
2792: (
2793: PROJECT_ID ,
2794: PLAN_VERSION_ID ,
2795: WBS_STRUCT_VERSION_ID ,

Line 2829: FROM pji_fm_extr_plnver3_T bv

2825: , DECODE(cbco.plan_version_id, -4, 'Y', 'N') -- curr_original flag
2826: , 'Y' -- baselined flag.
2827: , bv.SECONDARY_RBS_FLAG
2828: , bv.lp_flag
2829: FROM pji_fm_extr_plnver3_T bv
2830: , pji_xbs_denorm den
2831: , ( SELECT -3 plan_version_id FROM DUAL
2832: UNION ALL
2833: SELECT -4 FROM DUAL ) cbco

Line 2844: DELETE FROM pji_fm_extr_plnver3_t

2840: AND den.sub_id = bv.wbs_struct_version_id
2841: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF') -- Excluding 'LW'
2842: ;
2843:
2844: DELETE FROM pji_fm_extr_plnver3_t
2845: WHERE plan_version_id > 0;
2846: print_time(' Need only -3, -4 records, deleted other plan version. ');
2847:
2848:

Line 6497: DELETE FROM PJI_FM_EXTR_PLNVER3_T;

6493: ( p_package_name => g_package_name
6494: , x_return_status => l_return_status );
6495:
6496: DELETE FROM pji_fp_aggr_pjp1_t;
6497: DELETE FROM PJI_FM_EXTR_PLNVER3_T;
6498: DELETE FROM pji_fp_rmap_fpr_update_t;
6499: EXCEPTION
6500: WHEN OTHERS THEN
6501: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER