APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_FM_EXTR_PLNVER4

Line 808: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);

804:
805: ELSIF (p_online_flag = 'N') THEN
806:
807: /* DELETE FROM pji_rollup_level_status
808: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
809: Bug No. 4538102*/
810: DELETE FROM pji_rollup_level_status
811: WHERE (project_id,plan_version_id,plan_type_code ) IN
812: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver4); /*4771527 */

Line 812: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver4); /*4771527 */

808: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
809: Bug No. 4538102*/
810: DELETE FROM pji_rollup_level_status
811: WHERE (project_id,plan_version_id,plan_type_code ) IN
812: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver4); /*4771527 */
813:
814: IF (SQL%ROWCOUNT > 0) THEN
815:
816: /*

Line 819: tabname => 'PJI_FM_EXTR_PLNVER4', -- IN VARCHAR2,

815:
816: /*
817: FND_STATS.SET_TABLE_STATS(
818: ownname => 'PJI', -- IN VARCHAR2,
819: tabname => 'PJI_FM_EXTR_PLNVER4', -- IN VARCHAR2,
820: numrows => 1, -- IN NUMBER,
821: numblks => 1, -- IN NUMBER,
822: avgrlen => 100 --, -- IN NUMBER,
823: );

Line 828: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver4) /*4771527 */

824: */
825:
826: DELETE FROM pji_fp_xbs_accum_f
827: WHERE (project_id,plan_version_id,plan_type_code ) IN
828: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver4) /*4771527 */
829: AND (rbs_aggr_level = 'R'
830: OR (rbs_aggr_level = 'L'
831: AND wbs_rollup_flag = 'Y')) ;
832: g_smart_rows_deleted := SQL%ROWCOUNT;