[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
736: ,DECODE(rbs_dummy.rbs_elem_id, 'OLD' , 0-pbl.quantity, 'NEW', pbl.quantity)
737: ,pra.resource_class_code
738: ,pra.rate_based_flag
739: FROM pa_projects_all p
740: ,pa_resource_assignments pra
741: ,pa_budget_versions pbv
742: ,pa_proj_fp_options pfo
743: ,pa_rbs_plans_out_tmp tmp
744: ,pa_budget_lines pbl
837: ,pbl.quantity
838: ,pra.resource_class_code
839: ,pra.rate_based_flag
840: FROM pa_projects_all p
841: ,pa_resource_assignments pra
842: ,pa_budget_versions pbv
843: ,pa_proj_fp_options pfo
844: ,pa_fp_ra_map_tmp tmp
845: ,pa_budget_lines pbl
1025: FROM pa_projects_all p,
1026: pa_proj_fp_options pfo,
1027: pa_budget_versions pbv,
1028: pa_budget_lines pbl,
1029: pa_resource_assignments pra
1030: WHERE p.project_id=pbv.project_id
1031: AND pbv.budget_version_id=p_budget_version_id
1032: AND pfo.fin_plan_version_id=p_budget_version_id
1033: AND pbl.resource_assignment_id= pra.resource_assignment_id