DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 387: FROM okc_k_headers_all_b chr,

383: )
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',