APPS.PJI_REP_UTIL dependencies on PJI_PLAN_EXTR_TMP

Line 611: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

607: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
608: END IF;
609:
610: BEGIN
611: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
612: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
613: END;
614:
615: DELETE FROM PJI_PLAN_EXTR_TMP;

Line 612: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

608: END IF;
609:
610: BEGIN
611: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
612: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
613: END;
614:
615: DELETE FROM PJI_PLAN_EXTR_TMP;
616: IF p_prg_flag = 'Y' THEN

Line 615: DELETE FROM PJI_PLAN_EXTR_TMP;

611: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
612: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
613: END;
614:
615: DELETE FROM PJI_PLAN_EXTR_TMP;
616: IF p_prg_flag = 'Y' THEN
617: -- populate the plan versions ids into the temp table for the program hierarchy
618: INSERT INTO PJI_PLAN_EXTR_TMP
619: (PROJECT_ID, PLAN_VER_ID, LPB_PLAN_VER_ID, BASE_PLAN_VER_ID, PLAN1_VER_ID, PLAN2_VER_ID, STRUCT_VER_ID)

Line 618: INSERT INTO PJI_PLAN_EXTR_TMP

614:
615: DELETE FROM PJI_PLAN_EXTR_TMP;
616: IF p_prg_flag = 'Y' THEN
617: -- populate the plan versions ids into the temp table for the program hierarchy
618: INSERT INTO PJI_PLAN_EXTR_TMP
619: (PROJECT_ID, PLAN_VER_ID, LPB_PLAN_VER_ID, BASE_PLAN_VER_ID, PLAN1_VER_ID, PLAN2_VER_ID, STRUCT_VER_ID)
620: SELECT
621: header.project_id,
622: MAX(DECODE(header_p.plan_version_id,p_current_version_id,header.plan_version_id,NULL)),

Line 654: INSERT INTO PJI_PLAN_EXTR_TMP

650: AND header.wbs_version_id = denorm.sub_id
651: AND header.wp_flag = 'Y'
652: GROUP BY header.project_id;
653: ELSE
654: INSERT INTO PJI_PLAN_EXTR_TMP
655: (PROJECT_ID, PLAN_VER_ID, LPB_PLAN_VER_ID, BASE_PLAN_VER_ID, PLAN1_VER_ID, PLAN2_VER_ID, STRUCT_VER_ID)
656: VALUES
657: (p_project_id, p_current_version_id, p_latest_version_id, p_baselined_version_id, p_plan1_version_id, p_plan2_version_id, p_curr_wbs_vers_id);
658: END IF;