APPS.PA_MC_UPG dependencies on PA_MC_UPG

Line 1: PACKAGE BODY PA_MC_UPG AS

1: PACKAGE BODY PA_MC_UPG AS
2: --$Header: PAXMCUPB.pls 120.5 2005/08/26 11:07:42 skannoji noship $
3:
4: /* Declare variables */
5:

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)

Line 1620: END PA_MC_UPG;

1616: return v_rate_date;
1617: END Get_Rate_Date;
1618: ------------------------------------------------------------------------
1619:
1620: END PA_MC_UPG;