3316: ,l_rep_pf_act_rev_tab
3317: FROM pa_budget_lines
3318: WHERE budget_version_id = P_BUDGET_VERSION_ID;
3319: ELSE
3320: DELETE FROM pa_fp_calc_amt_tmp1;
3321: FORALL i IN 1..p_res_asg_id_tab.count
3322: INSERT INTO pa_fp_calc_amt_tmp1 (resource_assignment_id)
3323: VALUES (p_res_asg_id_tab(i));
3324:
3318: WHERE budget_version_id = P_BUDGET_VERSION_ID;
3319: ELSE
3320: DELETE FROM pa_fp_calc_amt_tmp1;
3321: FORALL i IN 1..p_res_asg_id_tab.count
3322: INSERT INTO pa_fp_calc_amt_tmp1 (resource_assignment_id)
3323: VALUES (p_res_asg_id_tab(i));
3324:
3325: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N2)*/
3326: bl.budget_line_id,
3321: FORALL i IN 1..p_res_asg_id_tab.count
3322: INSERT INTO pa_fp_calc_amt_tmp1 (resource_assignment_id)
3323: VALUES (p_res_asg_id_tab(i));
3324:
3325: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N2)*/
3326: bl.budget_line_id,
3327: bl.resource_assignment_id,
3328: bl.start_date,
3329: bl.end_date,
3419: ,l_rep_prj_act_rev_tab
3420: ,l_rep_pf_act_raw_cost_tab
3421: ,l_rep_pf_act_burd_cost_tab
3422: ,l_rep_pf_act_rev_tab
3423: FROM pa_budget_lines bl, pa_fp_calc_amt_tmp1 tmp
3424: WHERE bl.budget_version_id = P_BUDGET_VERSION_ID
3425: AND bl.resource_assignment_id = tmp.resource_assignment_id;
3426: END IF;
3427: