DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 384: FROM okc_k_headers_all_b chr,

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