DBA Data[Home] [Help]

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_TRX_TYPES_TL

Line 3693: FROM okl_trx_types_tl

3689: FUNCTION get_try_id (p_try_name IN VARCHAR2) RETURN NUMBER IS
3690:
3691: CURSOR c_try IS
3692: SELECT id
3693: FROM okl_trx_types_tl
3694: WHERE name = p_try_name
3695: AND language = 'US';
3696:
3697: l_try_id NUMBER;

Line 7167: FROM okl_trx_types_tl

7163:
7164:
7165: CURSOR try_csr_lpd IS
7166: SELECT id
7167: FROM okl_trx_types_tl
7168: WHERE LANGUAGE = 'US'
7169: AND name = 'Loan Paydown';
7170:
7171: CURSOR try_csr_ppd IS

Line 7173: FROM okl_trx_types_tl

7169: AND name = 'Loan Paydown';
7170:
7171: CURSOR try_csr_ppd IS
7172: SELECT id
7173: FROM okl_trx_types_tl
7174: WHERE LANGUAGE = 'US'
7175: AND name = 'Principal Paydown';
7176:
7177: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS