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 7151: FROM okl_trx_types_tl

7147:
7148:
7149: CURSOR try_csr_lpd IS
7150: SELECT id
7151: FROM okl_trx_types_tl
7152: WHERE LANGUAGE = 'US'
7153: AND name = 'Loan Paydown';
7154:
7155: CURSOR try_csr_ppd IS

Line 7157: FROM okl_trx_types_tl

7153: AND name = 'Loan Paydown';
7154:
7155: CURSOR try_csr_ppd IS
7156: SELECT id
7157: FROM okl_trx_types_tl
7158: WHERE LANGUAGE = 'US'
7159: AND name = 'Principal Paydown';
7160:
7161: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS