APPS.OKL_CONTRACT_STATUS_PVT dependencies on OKL_TRX_CONTRACTS
Line 49: select 'X' from okl_trx_contracts ktx
45: cursor stm_csr( chrId NUMBER ) is
46: select 'Y'
47: from dual
48: where exists ( 49: select 'X' from okl_trx_contracts ktx 50: where ktx.KHR_ID = chrId
51: and UPPER(ktx.TSU_CODE) = 'WORKING'
52: --rkuttiya added for 12.1.1 Multi GAAP
53: and ktx.representation_type = 'PRIMARY'