DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKI_DBI_CURRENCY_PVT

Line 715: ELSE oki_dbi_currency_pvt.get_trx_rate_type_init(

711: ) SELECT k.id
712: , trunc(COALESCE(k.conversion_date, k.date_approved, k.creation_date)) CONVERSION_DATE
713: , (CASE WHEN k.currency_code = k.sob_currency_code
714: THEN l_rate_type
715: ELSE oki_dbi_currency_pvt.get_trx_rate_type_init(
716: k.id
717: , k.currency_code
718: , k.sob_currency_code
719: , NVL(k.date_approved, k.creation_date)

Line 1387: ELSE oki_dbi_currency_pvt.get_trx_rate_type(

1383: h.id chr_id
1384: , trunc(COALESCE(h.conversion_rate_date, h.date_approved, h.creation_date)) AS CONVERSION_DATE
1385: , (CASE WHEN h.currency_code = sob.currency_code
1386: THEN l_rate_type
1387: ELSE oki_dbi_currency_pvt.get_trx_rate_type(
1388: h.id
1389: , h.currency_code
1390: , sob.currency_code
1391: , h.creation_date