APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_FP_CALC_AMT_TMP1

Line 3320: DELETE FROM pa_fp_calc_amt_tmp1;

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:

Line 3322: INSERT INTO pa_fp_calc_amt_tmp1 (resource_assignment_id)

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,

Line 3325: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N2)*/

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,

Line 3423: FROM pa_budget_lines bl, pa_fp_calc_amt_tmp1 tmp

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: