APPS.OKL_PRB_UPGRADE_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 799: FROM okc_k_headers_all_b chr

795: AND opp.process_status = 'PENDING_ASSIGNMENT'
796: AND opp.assigned_process = TO_CHAR(l_seq_next)
797: AND EXISTS
798: ( SELECT 'INVALID'
799: FROM okc_k_headers_all_b chr
800: WHERE chr.id = opp.khr_id
801: AND chr.sts_code NOT IN ( 'COMPLETE','BOOKED','APPROVED' )
802: );
803: log_msg(FND_FILE.LOG, 'Checking: Contract status should be Booked/Complete/Approved - End: '

Line 1071: FROM okc_k_headers_all_b a

1067: FOR non_upg_index IN l_non_upg_contracts_tbl.FIRST .. l_non_upg_contracts_tbl.LAST
1068: LOOP
1069: SELECT b.meaning
1070: INTO l_k_status
1071: FROM okc_k_headers_all_b a
1072: ,okc_statuses_tl b
1073: WHERE a.contract_number = l_non_upg_contracts_tbl(non_upg_index).contract_number
1074: AND a.sts_code = b.code
1075: AND b.language = USERENV('LANG');