DBA Data[Home] [Help]

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'