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_PLAN_MATRIX dependencies on PA_FIN_PLAN_LINES_TMP

Line 344: FROM Pa_Fin_Plan_Lines_Tmp;

340: l_qty_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
341: CURSOR Main_Tmp_Cur IS
342: SELECT DISTINCT Resource_Assignment_Id,
343: Source_Txn_Currency_Code
344: FROM Pa_Fin_Plan_Lines_Tmp;
345: BEGIN
346: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
347: l_debug_mode := NVL(l_debug_mode, 'Y');
348: PA_DEBUG.Set_Curr_Function( p_function => 'Populate_Budget_Lines',

Line 494: FROM PA_FIN_PLAN_LINES_TMP

490: l_prec_txn_burdened_cost,
491: l_prec_txn_revenue,
492: l_prec_txn_curr_code,
493: l_prec_txn_quantity
494: FROM PA_FIN_PLAN_LINES_TMP
495: WHERE bucketing_period_code = l_bucketing_period_code
496: AND resource_assignment_id = main_cur_rec.resource_assignment_id
497: AND currency_type = 'TRANSACTION'
498: AND source_txn_currency_code = main_cur_rec.source_txn_currency_code;

Line 518: FROM PA_FIN_PLAN_LINES_TMP

514: INTO l_prec_proj_raw_cost,
515: l_prec_proj_burdened_cost,
516: l_prec_proj_revenue,
517: l_prec_proj_curr_code
518: FROM PA_FIN_PLAN_LINES_TMP
519: WHERE bucketing_period_code = l_bucketing_period_code
520: AND resource_assignment_id = main_cur_rec.resource_assignment_id
521: AND currency_type = 'PROJECT'
522: AND source_txn_currency_code = main_cur_rec.source_txn_currency_code ;

Line 541: FROM PA_FIN_PLAN_LINES_TMP

537: INTO l_prec_func_raw_cost,
538: l_prec_func_burdened_cost,
539: l_prec_func_revenue,
540: l_prec_func_curr_code
541: FROM PA_FIN_PLAN_LINES_TMP
542: WHERE bucketing_period_code = l_bucketing_period_code
543: AND resource_assignment_id = main_cur_rec.resource_assignment_id
544: AND currency_type = 'PROJ_FUNCTIONAL'
545: AND source_txn_currency_code = main_cur_rec.source_txn_currency_code;

Line 767: FROM PA_FIN_PLAN_LINES_TMP

763: l_succ_txn_burdened_cost,
764: l_succ_txn_revenue,
765: l_succ_txn_curr_code,
766: l_succ_txn_quantity
767: FROM PA_FIN_PLAN_LINES_TMP
768: WHERE bucketing_period_code = l_bucketing_period_code
769: AND resource_assignment_id = main_cur_rec.resource_assignment_id
770: AND currency_type = 'TRANSACTION'
771: AND source_txn_currency_code = main_cur_rec.source_txn_currency_code;

Line 791: FROM PA_FIN_PLAN_LINES_TMP

787: INTO l_succ_proj_raw_cost,
788: l_succ_proj_burdened_cost,
789: l_succ_proj_revenue,
790: l_succ_proj_curr_code
791: FROM PA_FIN_PLAN_LINES_TMP
792: WHERE bucketing_period_code = l_bucketing_period_code
793: AND resource_assignment_id = main_cur_rec.resource_assignment_id
794: AND currency_type = 'PROJECT'
795: AND source_txn_currency_code = main_cur_rec.source_txn_currency_code;

Line 814: FROM PA_FIN_PLAN_LINES_TMP

810: INTO l_succ_func_raw_cost,
811: l_succ_func_burdened_cost,
812: l_succ_func_revenue,
813: l_succ_func_curr_code
814: FROM PA_FIN_PLAN_LINES_TMP
815: WHERE bucketing_period_code = l_bucketing_period_code
816: AND resource_assignment_id = main_cur_rec.resource_assignment_id
817: AND currency_type = 'PROJ_FUNCTIONAL'
818: AND source_txn_currency_code = main_cur_rec.source_txn_currency_code;

Line 1386: Pa_Fin_Plan_Lines_Tmp;

1382: Currency_Type,
1383: Currency_Code,
1384: Source_Txn_Currency_Code
1385: FROM
1386: Pa_Fin_Plan_Lines_Tmp;
1387:
1388:
1389: CURSOR Bl_Cur(c_resource_assignment_id NUMBER,
1390: c_object_id NUMBER,

Line 1427: FROM Pa_Fin_Plan_Lines_Tmp

1423: Margin_Percentage,
1424: Bucketing_Period_Code, -- added this column in the cursor
1425: Parent_Assignment_Id, -- added this column in the cursor
1426: NVL(Delete_Flag,'N') -- added this column in the cursor
1427: FROM Pa_Fin_Plan_Lines_Tmp
1428: WHERE Resource_Assignment_Id = c_resource_assignment_id AND
1429: Object_Id = c_object_id AND
1430: Object_Type_Code = c_object_type_code AND
1431: Currency_Type = c_currency_type AND

Line 2200: FROM pa_fin_plan_lines_tmp pfpltmp;

2196: SELECT min(pfpltmp.start_date),
2197: max(pfpltmp.start_date)
2198: INTO l_min_pa_fp_ln_tmp_st_dt,
2199: l_max_pa_fp_ln_tmp_st_dt
2200: FROM pa_fin_plan_lines_tmp pfpltmp;
2201:
2202: -- Get the projfunc and project currency code for this project id
2203: SELECT project_currency_code,
2204: projfunc_currency_code

Line 2212: SELECT count(*) into l_count_for_pop_call FROM PA_FIN_PLAN_LINES_TMP

2208: WHERE project_id = l_project_id;
2209:
2210: /* Change for Bug 2641475 Ends */
2211:
2212: SELECT count(*) into l_count_for_pop_call FROM PA_FIN_PLAN_LINES_TMP
2213: WHERE bucketing_period_code = 'PD';
2214: IF (l_count_for_pop_call <> 0) THEN
2215: Populate_Budget_Lines
2216: (

Line 2269: SELECT count(*) into l_count_for_pop_call FROM PA_FIN_PLAN_LINES_TMP

2265: END IF;
2266: /* Change for Bug 2641475 ends */
2267: END IF;
2268:
2269: SELECT count(*) into l_count_for_pop_call FROM PA_FIN_PLAN_LINES_TMP
2270: WHERE bucketing_period_code = 'SD';
2271: IF (l_count_for_pop_call <> 0) THEN
2272: Populate_Budget_Lines
2273: (

Line 2471: Pa_Fin_Plan_Lines_Tmp bl WHERE

2467: l_prev_head_count_adj,
2468: l_prev_margin,
2469: l_prev_margin_perc
2470: FROM
2471: Pa_Fin_Plan_Lines_Tmp bl WHERE
2472: bl.Resource_Assignment_Id = main_cur_rec.resource_assignment_id AND
2473: bl.Object_Type_Code = main_cur_rec.object_type_code AND
2474: bl.Object_Id = main_cur_rec.object_id AND
2475: bl.Currency_Type = main_cur_rec.currency_type AND

Line 2521: Pa_Fin_Plan_Lines_Tmp bl WHERE

2517: l_next_head_count,
2518: l_next_head_count_adj,
2519: l_prev_margin,
2520: l_prev_margin_perc FROM
2521: Pa_Fin_Plan_Lines_Tmp bl WHERE
2522: bl.Resource_Assignment_Id = main_cur_rec.resource_assignment_id AND
2523: bl.Object_Type_Code = main_cur_rec.object_type_code AND
2524: bl.Object_Id = main_cur_rec.object_id AND
2525: bl.Currency_Type = main_cur_rec.currency_type AND