APPS.GL_CURRENCY_API dependencies on GL_DAILY_RATES

Line 135: New Turky Currency -> USD in GL_DAILY_RATES table.

131: USD, then we need to follow the following rule after 01-01-2005.
132: First find rate between
133: OLD Turky Currency -> New Turky Currency in GL_FIXED_CONV_RATES
134: Then
135: New Turky Currency -> USD in GL_DAILY_RATES table.
136: The following code added to do this job.
137: +-----------------------------------------------------------------------*/
138:
139: /* ********************************************************************+

Line 145: | New Currency -> EURO from the GL_DAILY_RATES |

141: | The rate may be calculated between two currencies as follows |
142: | |
143: | 1) Old Currency to French Franks |
144: | Old Currency -> New Currency from the GL_FIXED_CONV_RATES table |
145: | New Currency -> EURO from the GL_DAILY_RATES |
146: | EURO -> FRENCH FRANK fixed rate from the FND_CURRENCIES |
147: | |
148: | 2) USD to New Currency |
149: | USD -> New CURRENCY from the GL Daily Rates Table. |

Line 149: | USD -> New CURRENCY from the GL Daily Rates Table. |

145: | New Currency -> EURO from the GL_DAILY_RATES |
146: | EURO -> FRENCH FRANK fixed rate from the FND_CURRENCIES |
147: | |
148: | 2) USD to New Currency |
149: | USD -> New CURRENCY from the GL Daily Rates Table. |
150: | |
151: | 3) USD to Old Currency |
152: | USD -> New CURRENCY from the GL Daily Rates Table. |
153: | New curency -> Old Currency fixed rate |

Line 152: | USD -> New CURRENCY from the GL Daily Rates Table. |

148: | 2) USD to New Currency |
149: | USD -> New CURRENCY from the GL Daily Rates Table. |
150: | |
151: | 3) USD to Old Currency |
152: | USD -> New CURRENCY from the GL Daily Rates Table. |
153: | New curency -> Old Currency fixed rate |
154: | from GL Fixed Conv Rates |
155: | |
156: | 4) Old Currency to CAD |

Line 159: | New Currency -> CAD from the GL_DAILY_RATES |

155: | |
156: | 4) Old Currency to CAD |
157: | Old Currency -> New Currency from |
158: | the GL_FIXED_CONV_RATES table |
159: | New Currency -> CAD from the GL_DAILY_RATES |
160: | |
161: +######################################################################*/
162: -- Check the passed currencies have any fixed relationships exist or not.
163: -- This check avoids unnecssary processing if there is no fixed

Line 190: | x_to_currency from GL_DAILY_RATES table. |

186: | If there is a rate, then it is fine, otherwise try to find the |
187: | inverse rate by querying on replacement currency. |
188: | If there exists a fixed conversion relationship, then set the |
189: | x_from_currency to retrive the rate between the new currency to the |
190: | x_to_currency from GL_DAILY_RATES table. |
191: | |
192: | ************THIS PART HANDLES ON THE FROM CURRENCY SIDE.********* |
193: | |
194: | IF x_from_currency = OLD TURKY currency |

Line 199: | GL Daily Rates table. |

195: | Then it finds OLD TURKY CURRENCY to NEW TURKEY CURRENCY |
196: | If x_to_currency = NEW TURKY CURRENCY then this part |
197: | alone returns the final rate. |
198: | Else It will find the other part of the rate from |
199: | GL Daily Rates table. |
200: | New Turky Currency to USD |
201: +---------------------------------------------------------------------*/
202:
203: IF ( l_continue) THEN

Line 304: -- Get conversion rate between the two currencies from GL_DAILY_RATES

300:
301: rate := 1;
302:
303: ELSE
304: -- Get conversion rate between the two currencies from GL_DAILY_RATES
305: SELECT conversion_rate
306: INTO rate
307: FROM GL_DAILY_RATES
308: WHERE from_currency = l_from_currency

Line 307: FROM GL_DAILY_RATES

303: ELSE
304: -- Get conversion rate between the two currencies from GL_DAILY_RATES
305: SELECT conversion_rate
306: INTO rate
307: FROM GL_DAILY_RATES
308: WHERE from_currency = l_from_currency
309: AND to_currency = l_to_currency
310: AND conversion_date = trunc(x_conversion_date)
311: AND conversion_type = x_conversion_type;

Line 357: FROM GL_DAILY_RATES

353: -- x_max_roll_days prior to x_conversion_date AND x_conversion_date.
354: CURSOR closest_rate_curr(g_from_currency VARCHAR2,
355: g_to_currency VARCHAR2) IS
356: SELECT conversion_rate
357: FROM GL_DAILY_RATES
358: WHERE from_currency = g_from_currency
359: AND to_currency = g_to_currency
360: AND conversion_type = x_conversion_type
361: AND conversion_date BETWEEN