[Home] [Help]
883:
884: /* We are mapping the approved cost budget version
885: planning attributes to target budget version
886: resource list and the amounts will be
887: populated in the pa_fp_calc_amt_tmp3 table only
888: for the periods till the actual thru period */
889:
890: IF P_PA_DEBUG_MODE = 'Y' THEN
891: pa_fp_gen_amount_utils.fp_debug
921: DELETE PA_RES_LIST_MAP_TMP4;
922: INSERT INTO PA_RES_LIST_MAP_TMP4
923: ( txn_task_id,
924: txn_resource_list_member_id )
925: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N1)*/
926: DISTINCT
927: task_id,
928: res_list_member_id
929: FROM PA_FP_CALC_AMT_TMP3
925: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N1)*/
926: DISTINCT
927: task_id,
928: res_list_member_id
929: FROM PA_FP_CALC_AMT_TMP3
930: WHERE plan_version_id = p_app_cost_bdgt_ver_id;
931:
932: select count(*) into l_count from pa_res_list_map_tmp4 where rownum=1;
933: --dbms_output.put_line('Number of records inserted into tmp4 from tmp3 = ' || l_count);
1019: RETURN;
1020: END IF;
1021:
1022: /* Bulk collect plan amounts, ordered by ascending ra_id. */
1023: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N1) INDEX(bl,PA_FP_CALC_AMT_TMP3_N1)*/
1024: tmp4.txn_resource_assignment_id,
1025: bl.txn_currency_code,
1026: nvl(sum(nvl(bl.quantity,0)),0),
1027: nvl(sum(nvl(bl.pc_raw_cost,0)),0),
1035: l_plan_pc_raw_cost_tab,
1036: l_plan_txn_raw_cost_tab,
1037: l_plan_pc_burd_cost_tab,
1038: l_plan_txn_burd_cost_tab
1039: FROM pa_fp_calc_amt_tmp3 bl,
1040: pa_res_list_map_tmp4 tmp4
1041: WHERE bl.plan_version_id = p_app_cost_bdgt_ver_id
1042: AND bl.task_id = tmp4.txn_task_id
1043: AND bl.res_list_member_id = tmp4.txn_resource_list_member_id