[Home] [Help]
211: l_pc_currency_code := p_fp_cols_tgt_rec.x_project_currency_code;
212: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
213: l_target_version_type := p_fp_cols_src_rec.x_version_type;
214: IF p_etc_source_code = 'FINANCIAL_PLAN' THEN
215: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
216: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
217: DECODE(l_currency_flag,
218: 'PC',l_pc_currency_code,
219: 'TC',txn_currency_code,
212: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
213: l_target_version_type := p_fp_cols_src_rec.x_version_type;
214: IF p_etc_source_code = 'FINANCIAL_PLAN' THEN
215: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
216: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
217: DECODE(l_currency_flag,
218: 'PC',l_pc_currency_code,
219: 'TC',txn_currency_code,
220: 'PFC',l_pfc_currency_code),
236: l_act_quantity_tab,
237: l_act_raw_cost_tab,
238: l_act_brdn_cost_tab,
239: l_act_revenue_tab
240: FROM PA_FP_FCST_GEN_TMP1
241: WHERE project_element_id = p_task_id
242: AND res_list_member_id = p_resource_list_member_id
243: AND data_type_code = 'ETC_FP'
244: GROUP BY DECODE(l_currency_flag,
322: from the source resource assignments that are mapped to the current target
323: resource assignment. */
324: FOR i IN 1..l_act_currency_code_tab.count LOOP
325: IF p_etc_source_code = 'FINANCIAL_PLAN' THEN
326: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
327: SUM(NVL(quantity,0)),
328: SUM(DECODE(l_currency_flag,
329: 'PC', NVL(prj_raw_cost,0),
330: 'TC', NVL(txn_raw_cost,0),
352: l_pc_rate_revenue,
353: l_pfc_rate_raw_cost,
354: l_pfc_rate_brdn_cost,
355: l_pfc_rate_revenue
356: FROM PA_FP_FCST_GEN_TMP1
357: WHERE project_element_id = p_task_id
358: AND res_list_member_id = p_resource_list_member_id
359: AND data_type_code = 'ETC_FP'
360: AND DECODE(l_currency_flag, 'TC',txn_currency_code,
736: l_pc_currency_code := p_fp_cols_tgt_rec.x_project_currency_code;
737: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
738: l_target_version_type := p_fp_cols_tgt_rec.x_version_type;
739: IF p_etc_source_code_tab(main_loop) = 'FINANCIAL_PLAN' THEN
740: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
741: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
742: DECODE(l_currency_flag,
743: 'PC',l_pc_currency_code,
744: 'TC',txn_currency_code,
737: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
738: l_target_version_type := p_fp_cols_tgt_rec.x_version_type;
739: IF p_etc_source_code_tab(main_loop) = 'FINANCIAL_PLAN' THEN
740: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
741: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
742: DECODE(l_currency_flag,
743: 'PC',l_pc_currency_code,
744: 'TC',txn_currency_code,
745: 'PFC',l_pfc_currency_code),
761: l_act_quantity_tab,
762: l_act_raw_cost_tab,
763: l_act_brdn_cost_tab,
764: l_act_revenue_tab
765: FROM PA_FP_FCST_GEN_TMP1
766: WHERE project_element_id = p_task_id_tab(main_loop)
767: AND res_list_member_id = p_res_list_member_id_tab(main_loop)
768: AND data_type_code = 'ETC_FP'
769: GROUP BY DECODE(l_currency_flag,
847: from the source resource assignments that are mapped to the current target
848: resource assignment. */
849: FOR i IN 1..l_act_currency_code_tab.count LOOP
850: IF p_etc_source_code_tab(main_loop) = 'FINANCIAL_PLAN' THEN
851: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
852: SUM(NVL(quantity,0)),
853: SUM(DECODE(l_currency_flag,
854: 'PC', NVL(prj_raw_cost,0),
855: 'TC', NVL(txn_raw_cost,0),
877: l_pc_rate_revenue,
878: l_pfc_rate_raw_cost,
879: l_pfc_rate_brdn_cost,
880: l_pfc_rate_revenue
881: FROM PA_FP_FCST_GEN_TMP1
882: WHERE project_element_id = p_task_id_tab(main_loop)
883: AND res_list_member_id = p_res_list_member_id_tab(main_loop)
884: AND data_type_code = 'ETC_FP'
885: AND DECODE(l_currency_flag, 'TC',txn_currency_code,