[Home] [Help]
798: RACTRL.KHR_ID CONTRACT_ID,
799: RACTRL.CONTRACT_NUMBER CONTRACT_NUMBER,
800: RACTRL.CUSTOMER_TRX_ID AR_INVOICE_NUMBER,
801: RACTRL.STREAM_TYPE STREAM_NAME,
802: OKL_AM_UTIL_PVT.get_chr_currency(RACTRL.KHR_ID) CURRENCY_CODE,
803: RACTRL.til_id_details TIL_ID,
804: RACTRL.TLD_ID TLD_ID
805: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,
806: AR_PAYMENT_SCHEDULES_ALL APS
984: END IF;
985:
986: -- Bug 7138249 start
987: -- Get the functional currency from AM_Util
988: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;
989:
990: -- Get the contract currency code
991: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(
992: c_pmnt_schedule_dtls_rec.contract_id);
987: -- Get the functional currency from AM_Util
988: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;
989:
990: -- Get the contract currency code
991: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(
992: c_pmnt_schedule_dtls_rec.contract_id);
993:
994: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
995: p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
990: -- Get the contract currency code
991: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(
992: c_pmnt_schedule_dtls_rec.contract_id);
993:
994: l_trans_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
995: p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
996: p_lookup_code=> 'ADJUSTMENTS',
997: p_validate_yn => 'Y');
998: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN