APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_FM_EXTR_PLNVER4

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

1082:
1083: ELSIF (p_online_flag = 'N') THEN
1084:
1085: /* DELETE FROM pji_rollup_level_status
1086: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
1087: Bug No. 4538102*/
1088: DELETE FROM pji_rollup_level_status
1089: WHERE (project_id,plan_version_id,plan_type_code ) IN
1090: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver4); /*4771527 */

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

1086: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
1087: Bug No. 4538102*/
1088: DELETE FROM pji_rollup_level_status
1089: WHERE (project_id,plan_version_id,plan_type_code ) IN
1090: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver4); /*4771527 */
1091:
1092: IF (SQL%ROWCOUNT > 0) THEN
1093:
1094: /*

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

1093:
1094: /*
1095: FND_STATS.SET_TABLE_STATS(
1096: ownname => 'PJI', -- IN VARCHAR2,
1097: tabname => 'PJI_FM_EXTR_PLNVER4', -- IN VARCHAR2,
1098: numrows => 1, -- IN NUMBER,
1099: numblks => 1, -- IN NUMBER,
1100: avgrlen => 100 --, -- IN NUMBER,
1101: );

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

1102: */
1103:
1104: DELETE FROM pji_fp_xbs_accum_f
1105: WHERE (project_id,plan_version_id,plan_type_code ) IN
1106: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver4) /*4771527 */
1107: AND (rbs_aggr_level = 'R'
1108: OR (rbs_aggr_level = 'L'
1109: AND wbs_rollup_flag = 'Y')) ;
1110: g_smart_rows_deleted := SQL%ROWCOUNT;