APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_FM_EXTR_PLAN_LINES

Line 4497: UPDATE PJI_FM_EXTR_PLAN_LINES bl

4493:
4494: PROCEDURE UPDATE_ACTUALS_TO_NULL IS
4495: BEGIN
4496:
4497: UPDATE PJI_FM_EXTR_PLAN_LINES bl
4498: SET
4499: bl.act_txn_raw_cost = NULL
4500: , bl.act_txn_burdened_cost = NULL
4501: , bl.act_txn_revenue = NULL

Line 4949: PJI_FM_EXTR_PLAN_LINES bl

4945: , bl.project_org_id project_org_id
4946: , ppa.carrying_out_organization_id project_organization_id
4947: , ver.plan_type_code plan_type_code /* 4471527 */
4948: FROM
4949: PJI_FM_EXTR_PLAN_LINES bl
4950: , PJI_FM_EXTR_PLNVER3_T ver
4951: , pa_projects_all ppa
4952: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4953: , pji_fp_rmap_fpr_update_t rwid

Line 5104: FROM PJI_FM_EXTR_PLAN_LINES epl

5100: , bv.original_flag original_flag
5101: , bv.current_original_flag current_original_flag
5102: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
5103: , 'N'
5104: FROM PJI_FM_EXTR_PLAN_LINES epl
5105: , pa_budget_versions bv
5106: , pa_proj_fp_options fpo
5107: WHERE
5108: epl.plan_version_id = bv.budget_version_id

Line 6793: delete from pji_fm_extr_plan_lines

6789: l_prev_pub_version_id := p_prev_pub_version_id;
6790:
6791: -- Fix for bug : 4213245
6792: /*
6793: delete from pji_fm_extr_plan_lines
6794: where
6795: PLAN_VERSION_ID = p_new_pub_version_id and
6796: ETC_QUANTITY is null and
6797: ETC_TXN_BURDENED_COST is null and

Line 7200: PJI_FM_EXTR_PLAN_LINES bl

7196: , bl.project_org_id project_org_id
7197: , ppa.carrying_out_organization_id project_organization_id
7198: , ver.plan_type_code plan_type_code /* 4471527 */
7199: FROM
7200: PJI_FM_EXTR_PLAN_LINES bl
7201: , PJI_FM_EXTR_PLNVER3_T ver
7202: , PA_PROJECTS_ALL ppa
7203: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7204: , pji_fp_rmap_fpr_update_t rwid