APPS.PA_FP_CALC_UTILS dependencies on PA_FP_GEN_RATE_TMP

Line 1121: INSERT INTO pa_fp_gen_rate_tmp fptmp

1117: and perdRec.time_phased_code = 'N' and g_refresh_rates_flag = 'N'
1118: and g_budget_version_type = 'ALL'
1119: and g_source_context = 'RESOURCE_ASSIGNMENT' Then
1120:
1121: INSERT INTO pa_fp_gen_rate_tmp fptmp
1122: (fptmp.target_res_asg_id
1123: ,fptmp.txn_currency_code
1124: ,fptmp.raw_cost_rate
1125: ,fptmp.burdened_cost_rate

Line 1139: from pa_fp_gen_rate_tmp fptmp1

1135: AND tmp.cost_rate_override = 0
1136: AND tmp.burden_cost_rate_override = 0
1137: AND tmp.bill_rate_override = 1
1138: AND NOT EXISTS (select null
1139: from pa_fp_gen_rate_tmp fptmp1
1140: where fptmp1.target_res_asg_id = tmp.resource_assignment_id
1141: and fptmp1.txn_currency_code = tmp.txn_currency_code
1142: );
1143: print_msg('Number of records inserted into pa_fp_gen_rate_tmp['||sql%rowcount||']');

Line 1143: print_msg('Number of records inserted into pa_fp_gen_rate_tmp['||sql%rowcount||']');

1139: from pa_fp_gen_rate_tmp fptmp1
1140: where fptmp1.target_res_asg_id = tmp.resource_assignment_id
1141: and fptmp1.txn_currency_code = tmp.txn_currency_code
1142: );
1143: print_msg('Number of records inserted into pa_fp_gen_rate_tmp['||sql%rowcount||']');
1144: End If;
1145: End If; --}
1146:
1147: exception