APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 2668: FROM okl_trx_contracts_all

2664: FUNCTION first_activation_date (p_chr_id NUMBER) return DATE IS
2665:
2666: CURSOR l_okl_trx_contracts_csr(cp_khr_id IN NUMBER) IS
2667: SELECT transaction_date
2668: FROM okl_trx_contracts_all
2669: WHERE khr_id = cp_khr_id
2670: AND try_id = 252879000775029305619701078073046135725 --'Booking' transaction id
2671: AND tcn_type = 'BKG'
2672: ORDER BY transaction_date;