eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_CALC_AMT_TMP2

Line 4200: delete from pa_fp_calc_amt_tmp2;

4196: -- Bug 4549862: Moved initialization of l_rev_gen_method before
4197: -- initialization of l_calculate_mode earlier in the code.
4198:
4199: IF p_fp_cols_rec.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
4200: delete from pa_fp_calc_amt_tmp2;
4201:
4202: FOR i IN 1..l_res_assgn_id_tmp_tab.count LOOP
4203: SELECT SUM(quantity)
4204: INTO l_total_plan_quantity

Line 4208: INSERT INTO pa_fp_calc_amt_tmp2(

4204: INTO l_total_plan_quantity
4205: FROM pa_budget_lines
4206: WHERE resource_assignment_id = l_res_assgn_id_tmp_tab(i); /* Bug 4093872 - Column name corrected from budget_version_id to resource_assignment_id */
4207:
4208: INSERT INTO pa_fp_calc_amt_tmp2(
4209: resource_assignment_id,
4210: total_plan_quantity)
4211: VALUES(
4212: l_res_assgn_id_tmp_tab(i),

Line 6990: SELECT /+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)/

6986: p_module_name => l_module_name,
6987: p_log_level => 5);
6988: END IF;
6989:
6990: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
6991: tmp.RESOURCE_ASSIGNMENT_ID,
6992: tmp.total_plan_quantity,
6993: ra.task_id,
6994: ra.resource_list_member_id,

Line 7088: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,

7084: l_rev_res_class_rt_sch_id_tab,
7085: l_cost_res_class_rt_sch_id_tab,
7086:
7087: l_res_format_id_tab
7088: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
7089: pa_projects_all proj, pa_tasks t,
7090: pa_proj_fp_options fp,
7091: pa_resource_list_members rlm
7092: WHERE tmp.resource_assignment_id = ra.resource_assignment_id

Line 7632: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,