[Home] [Help]
531: --This procedure populates the tmp table PJI_FM_EXTR_PLAN_LINES and calls the API
532: --PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE . The valid values for p_source are
533: -- 1. PA_RBS_PLANS_OUT_TMP (This is the tmp table which contains the mapped rbs elemend ids ). The PJI API will
534: -- be called for the rbs element ids availabe in the PA_RBS_PLANS_OUT_TMP, if the new rbs element id is different
535: -- from the already existing rbs element id in pa_resource_assignments. If the rbs element id is different then
536: ---------1.Reporting lines API will be called with negative amounts for the budget lines with
537: -- start_date <= etc_start_date with old rbs element id. The same API will be called for the same set of
538: -- budget lines with +ve amounts and new rbs element id again.
539: ---------2.Reporting lines API will NOT be called for the budget lines with start_date > etc_start_date. The
739: ,pra.resource_class_code
740: ,pra.rate_based_flag
741: ,pra.CBS_ELEMENT_ID
742: FROM pa_projects_all p
743: ,pa_resource_assignments pra
744: ,pa_budget_versions pbv
745: ,pa_proj_fp_options pfo
746: ,pa_rbs_plans_out_tmp tmp
747: ,pa_budget_lines pbl
842: ,pra.resource_class_code
843: ,pra.rate_based_flag
844: ,pra.CBS_ELEMENT_ID
845: FROM pa_projects_all p
846: ,pa_resource_assignments pra
847: ,pa_budget_versions pbv
848: ,pa_proj_fp_options pfo
849: ,pa_fp_ra_map_tmp tmp
850: ,pa_budget_lines pbl
1068: FROM pa_projects_all p,
1069: pa_proj_fp_options pfo,
1070: pa_budget_versions pbv,
1071: pa_budget_lines pbl,
1072: pa_resource_assignments pra
1073: WHERE p.project_id=pbv.project_id
1074: AND pbv.budget_version_id=p_budget_version_id
1075: AND pfo.fin_plan_version_id=p_budget_version_id
1076: AND pbl.resource_assignment_id= pra.resource_assignment_id