DBA Data[Home] [Help]

APPS.PA_MC_UPG dependencies on PA_MC_UPGRADE_RATES

Line 227: from PA_MC_UPGRADE_RATES

223: CURSOR C_currency IS
224: (SELECT distinct denom_currency_code
225: from pa_expenditure_items_all pei
226: where not exists (select null
227: from PA_MC_UPGRADE_RATES
228: where From_currency = pei.denom_currency_code
229: and To_Currency = G_Rep_Curr_Code
230: and Exchange_date = G_Fixed_Date
231: and Rate_Type = G_Fixed_Type)

Line 237: from PA_MC_UPGRADE_RATES

233: UNION
234: SELECT distinct bill_trans_currency_code
235: from pa_events pevt
236: where not exists (select null
237: from PA_MC_UPGRADE_RATES
238: where From_currency = pevt.bill_trans_currency_code
239: and To_Currency = G_Rep_Curr_Code
240: and Exchange_date = G_Fixed_Date
241: and Rate_Type = G_Fixed_Type)