APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_FP_XBS_ACCUM_F

Line 796: DELETE FROM pji_fp_xbs_accum_f

792: avgrlen => 100 --, -- IN NUMBER,
793: );
794: */
795:
796: DELETE FROM pji_fp_xbs_accum_f
797: WHERE (project_id,plan_version_id,plan_type_code) IN /*4771527 */
798: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t)
799: AND (rbs_aggr_level = 'R'
800: OR (rbs_aggr_level = 'L'

Line 826: DELETE FROM pji_fp_xbs_accum_f

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

Line 3231: INSERT INTO pji_fp_xbs_accum_f

3227: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
3228: ( p_package_name => g_package_name
3229: , x_return_status => x_processing_code );
3230:
3231: INSERT INTO pji_fp_xbs_accum_f
3232: (
3233: PROJECT_ID
3234: , PROJECT_ORG_ID
3235: , PROJECT_ORGANIZATION_ID

Line 3389: pji_fp_xbs_accum_f rl

3385: , rl.CUSTOM14
3386: , rl.CUSTOM15
3387: , rl.PLAN_TYPE_CODE /*4471527 */
3388: FROM
3389: pji_fp_xbs_accum_f rl
3390: , pji_pjp_wbs_header wh
3391: WHERE rl.project_id = wh.project_id
3392: AND rl.project_id = p_project_id
3393: AND rl.plan_type_id = p_plan_type_id

Line 5861: pji_fp_xbs_accum_f fact,

5857: fact.CUSTOM14,
5858: fact.CUSTOM15,
5859: fact.PLAN_TYPE_CODE /*4471527 */
5860: FROM
5861: pji_fp_xbs_accum_f fact,
5862: pji_pjp_wbs_header head
5863: WHERE
5864: fact.RBS_AGGR_LEVEL = 'L' AND
5865: fact.WBS_ROLLUP_FLAG = 'N' AND