eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_SOE dependencies on GL_DAILY_RATES

Line 853: (p_from_currency in gl_daily_rates.from_currency%type,

849: -- to be used by pay_sg_asg_elements_v
850: -- to convert the pay value from other currencies to BG currency
851: ------------------------------------------------------------------------
852: function get_exchange_rate
853: (p_from_currency in gl_daily_rates.from_currency%type,
854: p_to_currency in gl_daily_rates.to_currency%type,
855: eff_date in gl_daily_rates.conversion_date%type,
856: p_business_group_id in pay_user_columns.business_group_id%type )
857: return number is

Line 854: p_to_currency in gl_daily_rates.to_currency%type,

850: -- to convert the pay value from other currencies to BG currency
851: ------------------------------------------------------------------------
852: function get_exchange_rate
853: (p_from_currency in gl_daily_rates.from_currency%type,
854: p_to_currency in gl_daily_rates.to_currency%type,
855: eff_date in gl_daily_rates.conversion_date%type,
856: p_business_group_id in pay_user_columns.business_group_id%type )
857: return number is
858: CURSOR rate is SELECT gdr.conversion_rate

Line 855: eff_date in gl_daily_rates.conversion_date%type,

851: ------------------------------------------------------------------------
852: function get_exchange_rate
853: (p_from_currency in gl_daily_rates.from_currency%type,
854: p_to_currency in gl_daily_rates.to_currency%type,
855: eff_date in gl_daily_rates.conversion_date%type,
856: p_business_group_id in pay_user_columns.business_group_id%type )
857: return number is
858: CURSOR rate is SELECT gdr.conversion_rate
859: FROM gl_daily_rates gdr, gl_daily_conversion_types gdct

Line 859: FROM gl_daily_rates gdr, gl_daily_conversion_types gdct

855: eff_date in gl_daily_rates.conversion_date%type,
856: p_business_group_id in pay_user_columns.business_group_id%type )
857: return number is
858: CURSOR rate is SELECT gdr.conversion_rate
859: FROM gl_daily_rates gdr, gl_daily_conversion_types gdct
860: WHERE gdr.conversion_type = gdct.conversion_type
861: AND gdr.from_currency = p_from_currency
862: AND gdr.to_currency = p_to_currency
863: AND gdr.conversion_date = eff_date