DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT dependencies on OKL_K_HEADERS

Line 385: OKL_K_HEADERS khr

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