APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_FP_GEN_RATE_TMP

Line 4743: ,pa_fp_gen_rate_tmp fptmp

4739: */
4740: ,decode(p_generation_context,'REVENUE_MARKUP',
4741: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4742: FROM pa_fp_rollup_tmp tmp
4743: ,pa_fp_gen_rate_tmp fptmp
4744: ,pa_resource_assignments ra
4745: ,pa_fp_spread_calc_tmp caltmp
4746: WHERE caltmp.budget_version_id = p_budget_version_id
4747: AND caltmp.resource_assignment_id = ra.resource_assignment_id

Line 4779: ,pa_fp_gen_rate_tmp fptmp

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

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

4895: l_PROJFUNC_REV_DATE_TYPE_tab.delete;
4896: l_PROJFUNC_REV_RATE_DATE_tab.delete;
4897: l_markup_calculation_flag_tab.delete;
4898: g_stage :='Update_rollupTmp_OvrRates:103';
4899: --print_msg('Fetching rate overrides details from pa_fp_gen_rate_tmp tables');
4900: OPEN fptmpDetails;
4901: FETCH fptmpDetails BULK COLLECT INTO
4902: l_rowid_tab
4903: ,l_resource_assignment_id_tab