DBA Data[Home] [Help]

APPS.JE_IT_EXEMPT_LETTERS_PKG dependencies on GL_CURRENCY_API

Line 88: exchange_rate := gl_currency_api.get_rate_sql (rledger_rec.ledger_id,

84: for rledger_rec in c_alc_ledger(c_ledger_id)
85: loop
86:
87: -- get exchange rate for the additional ledger currency
88: exchange_rate := gl_currency_api.get_rate_sql (rledger_rec.ledger_id,
89: rledger_rec.currency_code,NULL,NULL);
90:
91:
92: INSERT INTO JE_IT_EXEMPT_LETTERS(

Line 277: exchange_rate :=gl_currency_api.get_rate_sql(rledger_rec.ledger_id,

273: -- Loop for each Additional ledger
274: For rledger_rec IN c_alc_ledger(c_ledger_id)
275: loop
276: -- get exchange rate for the additional ledger currency
277: exchange_rate :=gl_currency_api.get_rate_sql(rledger_rec.ledger_id,
278: rledger_rec.currency_code,NULL,NULL);
279:
280: UPDATE JE_IT_EXEMPT_LETTERS
281: SET