APPS.ISC_MAINT_WO_CST_ETL_PKG dependencies on FII_CURRENCY

Line 134: -- By the logic of the fii_currency.get_global_rate_primary

130:
131: l_all_rates_found boolean;
132:
133: -- Set up a cursor to get all the invalid rates.
134: -- By the logic of the fii_currency.get_global_rate_primary
135: -- API, the returned value is -ve if no rate exists:
136: -- -1 for dates with no rate.
137: -- -2 for unrecognized conversion rates.
138: -- Also, cross check with the org-date pairs in the staging table,

Line 232: -- Use the fii_currency.get_global_rate_primary function to get the

228: -- Get all the distinct organization and date pairs and the
229: -- base currency codes for the orgs into the conversion rates
230: -- work table.
231:
232: -- Use the fii_currency.get_global_rate_primary function to get the
233: -- conversion rate given a currency code and a date.
234: -- only attempt to get conversion rate for rows that are complete
235: -- (have complete_flag = 'Y')
236: --

Line 268: , 'Y', fii_currency.get_global_rate_primary

264: s.organization_id
265: , s.completion_date
266: , c.currency_code
267: , decode( s.completed_flag -- only attempt conversion for real completion dates
268: , 'Y', fii_currency.get_global_rate_primary
269: ( c.currency_code
270: , s.completion_date )
271: , 0
272: ) conversion_rate1

Line 276: , 'Y', fii_currency.get_global_rate_secondary

272: ) conversion_rate1
273: , decode( l_global_currency_code2
274: , null, 0 -- only attempt conversion if secondary currency defined
275: , decode( s.completed_flag -- only attempt conversion for real completion dates
276: , 'Y', fii_currency.get_global_rate_secondary
277: ( c.currency_code
278: , s.completion_date )
279: , 0
280: )