APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_FM_EXTR_PLAN_LINES

Line 4410: UPDATE PJI_FM_EXTR_PLAN_LINES bl

4406:
4407: PROCEDURE UPDATE_ACTUALS_TO_NULL IS
4408: BEGIN
4409:
4410: UPDATE PJI_FM_EXTR_PLAN_LINES bl
4411: SET
4412: bl.act_txn_raw_cost = NULL
4413: , bl.act_txn_burdened_cost = NULL
4414: , bl.act_txn_revenue = NULL

Line 4850: PJI_FM_EXTR_PLAN_LINES bl

4846: , bl.project_org_id project_org_id
4847: , ppa.carrying_out_organization_id project_organization_id
4848: , ver.plan_type_code plan_type_code /* 4471527 */
4849: FROM
4850: PJI_FM_EXTR_PLAN_LINES bl
4851: , PJI_FM_EXTR_PLNVER3_T ver
4852: , pa_projects_all ppa
4853: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4854: , pji_fp_rmap_fpr_update_t rwid

Line 5004: FROM PJI_FM_EXTR_PLAN_LINES epl

5000: , bv.original_flag original_flag
5001: , bv.current_original_flag current_original_flag
5002: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
5003: , 'N'
5004: FROM PJI_FM_EXTR_PLAN_LINES epl
5005: , pa_budget_versions bv
5006: , pa_proj_fp_options fpo
5007: WHERE
5008: epl.plan_version_id = bv.budget_version_id

Line 6670: delete from pji_fm_extr_plan_lines

6666: l_prev_pub_version_id := p_prev_pub_version_id;
6667:
6668: -- Fix for bug : 4213245
6669: /*
6670: delete from pji_fm_extr_plan_lines
6671: where
6672: PLAN_VERSION_ID = p_new_pub_version_id and
6673: ETC_QUANTITY is null and
6674: ETC_TXN_BURDENED_COST is null and

Line 7071: PJI_FM_EXTR_PLAN_LINES bl

7067: , bl.project_org_id project_org_id
7068: , ppa.carrying_out_organization_id project_organization_id
7069: , ver.plan_type_code plan_type_code /* 4471527 */
7070: FROM
7071: PJI_FM_EXTR_PLAN_LINES bl
7072: , PJI_FM_EXTR_PLNVER3_T ver
7073: , PA_PROJECTS_ALL ppa
7074: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7075: , pji_fp_rmap_fpr_update_t rwid