APPS.PJI_PJP_SUM_MAIN dependencies on PJI_FP_XBS_ACCUM_F

Line 1149: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null

1145: AND den.sub_id = bv.wbs_struct_version_id
1146: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF');
1147:
1148: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1149: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null
1150: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1151:
1152: DELETE pji_rollup_level_status hdr
1153: where hdr.plan_version_id < -1

Line 1150: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';

1146: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF');
1147:
1148: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1149: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null
1150: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1151:
1152: DELETE pji_rollup_level_status hdr
1153: where hdr.plan_version_id < -1
1154: and exists (select 1 from pji_fm_extr_plnver4 ver3

Line 1161: DELETE FROM pji_fp_xbs_accum_f fact

1157: and ver3.plan_version_id = hdr.plan_version_id
1158: and ver3.plan_version_id < -1);
1159:
1160:
1161: DELETE FROM pji_fp_xbs_accum_f fact
1162: WHERE fact.plan_version_id < -1
1163: and exists (select 1 from pji_fm_extr_plnver4 ver3
1164: where ver3.worker_id = p_worker_id
1165: and ver3.project_id = fact.project_id

Line 1336: FROM pji_fp_xbs_accum_f f

1332: , SYSDATE
1333: , SYSDATE
1334: , 0
1335: ,ver.PLAN_TYPE_CODE
1336: FROM pji_fp_xbs_accum_f f
1337: , pji_fm_extr_plnver4 ver
1338: WHERE 1 = 1
1339: AND ver.project_id = f.project_id
1340: AND ver.plan_version_id = f.plan_version_id

Line 2472: INSERT INTO pji_fp_xbs_accum_f fact

2468:
2469: -- pji_utils.write2log('Updated records in wbs_header'||sql%rowcount);
2470:
2471:
2472: INSERT INTO pji_fp_xbs_accum_f fact
2473: (
2474: PROJECT_ID
2475: , PROJECT_ORG_ID
2476: , PROJECT_ORGANIZATION_ID