DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on GL_DAILY_CONVERSION_TYPES

Line 294: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;

290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
293: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
294: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
295: l_Start_Date DATE;
296: l_End_Date DATE;
297: l_Task_Id NUMBER;
298: l_Uom VARCHAR2(25);

Line 782: FROM gl_daily_conversion_types

778: if ( InvRec.Exchange_Rate_Type is not null ) then
779:
780: SELECT User_Conversion_Type
781: INTO l_User_Conv_Type
782: FROM gl_daily_conversion_types
783: WHERE conversion_type = InvRec.Exchange_Rate_Type;
784:
785: else -- bug 4219497
786: l_user_conv_type := null;

Line 1150: FROM gl_daily_conversion_types

1146: if ( InvRec.Exchange_Rate_Type is not null ) then
1147:
1148: SELECT User_Conversion_Type
1149: INTO l_User_Conv_Type
1150: FROM gl_daily_conversion_types
1151: WHERE conversion_type = InvRec.Exchange_Rate_Type;
1152:
1153: else -- bug 4219497
1154: l_user_conv_type := null;

Line 1525: FROM gl_daily_conversion_types

1521: if ( InvRec.Exchange_Rate_Type is not null ) then
1522:
1523: SELECT User_Conversion_Type
1524: INTO l_User_Conv_Type
1525: FROM gl_daily_conversion_types
1526: WHERE conversion_type = InvRec.Exchange_Rate_Type;
1527:
1528: else -- bug 4219497
1529: l_user_conv_type := null;

Line 1890: FROM gl_daily_conversion_types

1886: if ( InvRec.Exchange_Rate_Type is not null ) then
1887:
1888: SELECT User_Conversion_Type
1889: INTO l_User_Conv_Type
1890: FROM gl_daily_conversion_types
1891: WHERE conversion_type = InvRec.Exchange_Rate_Type;
1892:
1893: else -- bug 4219497
1894: l_user_conv_type := null;