APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 2654: FROM okl_trx_contracts_all

2650: FUNCTION first_activation_date (p_chr_id NUMBER) return DATE IS
2651:
2652: CURSOR l_okl_trx_contracts_csr(cp_khr_id IN NUMBER) IS
2653: SELECT transaction_date
2654: FROM okl_trx_contracts_all
2655: WHERE khr_id = cp_khr_id
2656: AND try_id = 252879000775029305619701078073046135725 --'Booking' transaction id
2657: AND tcn_type = 'BKG'
2658: ORDER BY transaction_date;