DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT dependencies on OKL_K_HEADERS

Line 388: OKL_K_HEADERS khr

384: SELECT 'CONTRACT_FIN_EXTRACT', chr.contract_number, l_char_seq_num, 'PENDING_ASSIGNMENT', sysdate, chr.id ,
385: l_org_id,l_last_updated_by,sysdate,sysdate,l_last_updated_by,l_last_update_login,
386: l_request_id,l_program_id,sysdate
387: FROM okc_k_headers_all_b chr,
388: OKL_K_HEADERS khr
389: WHERE chr.id = khr.id
390: AND chr.SCS_CODE = 'LEASE'
391: AND chr.sts_code IN ('BANKRUPTCY_HOLD','ENTERED','BOOKED', 'COMPLETE', 'EVERGREEN', 'EXPIRED', 'INCOMPLETE',
392: 'LITIGATION_HOLD', 'NEW', 'PASSED', 'REVERSED', 'TERMINATED') --sechawla 13-jan-09 7693771