APPS.PA_FP_CALC_UTILS dependencies on PA_FP_GEN_RATE_TMP

Line 1128: INSERT INTO pa_fp_gen_rate_tmp fptmp

1124: and perdRec.time_phased_code = 'N' and g_refresh_rates_flag = 'N'
1125: and g_budget_version_type = 'ALL'
1126: and g_source_context = 'RESOURCE_ASSIGNMENT' Then
1127:
1128: INSERT INTO pa_fp_gen_rate_tmp fptmp
1129: (fptmp.target_res_asg_id
1130: ,fptmp.txn_currency_code
1131: ,fptmp.raw_cost_rate
1132: ,fptmp.burdened_cost_rate

Line 1146: from pa_fp_gen_rate_tmp fptmp1

1142: AND tmp.cost_rate_override = 0
1143: AND tmp.burden_cost_rate_override = 0
1144: AND tmp.bill_rate_override = 1
1145: AND NOT EXISTS (select null
1146: from pa_fp_gen_rate_tmp fptmp1
1147: where fptmp1.target_res_asg_id = tmp.resource_assignment_id
1148: and fptmp1.txn_currency_code = tmp.txn_currency_code
1149: );
1150: print_msg('Number of records inserted into pa_fp_gen_rate_tmp['||sql%rowcount||']');

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

1146: from pa_fp_gen_rate_tmp fptmp1
1147: where fptmp1.target_res_asg_id = tmp.resource_assignment_id
1148: and fptmp1.txn_currency_code = tmp.txn_currency_code
1149: );
1150: print_msg('Number of records inserted into pa_fp_gen_rate_tmp['||sql%rowcount||']');
1151: End If;
1152: End If; --}
1153:
1154: exception