APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_FP_XBS_ACCUM_F

Line 1074: DELETE FROM pji_fp_xbs_accum_f

1070: avgrlen => 100 --, -- IN NUMBER,
1071: );
1072: */
1073:
1074: DELETE FROM pji_fp_xbs_accum_f
1075: WHERE (project_id,plan_version_id,plan_type_code) IN /*4771527 */
1076: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t)
1077: AND (rbs_aggr_level = 'R'
1078: OR (rbs_aggr_level = 'L'

Line 1104: DELETE FROM pji_fp_xbs_accum_f

1100: avgrlen => 100 --, -- IN NUMBER,
1101: );
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'

Line 3607: INSERT INTO pji_fp_xbs_accum_f

3603: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
3604: ( p_package_name => g_package_name
3605: , x_return_status => x_processing_code );
3606:
3607: INSERT INTO pji_fp_xbs_accum_f
3608: (
3609: PROJECT_ID
3610: , PROJECT_ORG_ID
3611: , PROJECT_ORGANIZATION_ID

Line 3765: pji_fp_xbs_accum_f rl

3761: , rl.CUSTOM14
3762: , rl.CUSTOM15
3763: , rl.PLAN_TYPE_CODE /*4471527 */
3764: FROM
3765: pji_fp_xbs_accum_f rl
3766: , pji_pjp_wbs_header wh
3767: WHERE rl.project_id = wh.project_id
3768: AND rl.project_id = p_project_id
3769: AND rl.plan_type_id = p_plan_type_id

Line 6381: pji_fp_xbs_accum_f fact,

6377: fact.CUSTOM14,
6378: fact.CUSTOM15,
6379: fact.PLAN_TYPE_CODE /*4471527 */
6380: FROM
6381: pji_fp_xbs_accum_f fact,
6382: pji_pjp_wbs_header head
6383: WHERE
6384: fact.RBS_AGGR_LEVEL = 'L' AND
6385: fact.WBS_ROLLUP_FLAG = 'N' AND