APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_FP_GEN_RATE_TMP

Line 4778: ,pa_fp_gen_rate_tmp fptmp

4774: */
4775: ,decode(p_generation_context,'REVENUE_MARKUP',
4776: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4777: FROM pa_fp_rollup_tmp tmp
4778: ,pa_fp_gen_rate_tmp fptmp
4779: ,pa_resource_assignments ra
4780: ,pa_fp_spread_calc_tmp caltmp
4781: WHERE caltmp.budget_version_id = p_budget_version_id
4782: AND caltmp.resource_assignment_id = ra.resource_assignment_id

Line 4814: ,pa_fp_gen_rate_tmp fptmp

4810: ,fptmp.revenue_bill_rate bill_rate_override
4811: ,decode(p_generation_context,'REVENUE_MARKUP',
4812: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4813: FROM pa_fp_rollup_tmp tmp
4814: ,pa_fp_gen_rate_tmp fptmp
4815: ,pa_resource_assignments ra
4816: ,pa_fp_spread_calc_tmp caltmp
4817: WHERE caltmp.budget_version_id = p_budget_version_id
4818: AND caltmp.resource_assignment_id = ra.resource_assignment_id

Line 4934: --print_msg('Fetching rate overrides details from pa_fp_gen_rate_tmp tables');

4930: l_PROJFUNC_REV_DATE_TYPE_tab.delete;
4931: l_PROJFUNC_REV_RATE_DATE_tab.delete;
4932: l_markup_calculation_flag_tab.delete;
4933: g_stage :='Update_rollupTmp_OvrRates:103';
4934: --print_msg('Fetching rate overrides details from pa_fp_gen_rate_tmp tables');
4935: OPEN fptmpDetails;
4936: FETCH fptmpDetails BULK COLLECT INTO
4937: l_rowid_tab
4938: ,l_resource_assignment_id_tab