APPS.OKE_CONTRACT_PUB dependencies on OKC_STATUSES_B
Line 3940: FROM OKC_STATUSES_B ST, OKC_K_HEADERS_B KH
3936: AND K_HEADER_ID IN (SELECT BOA_ID FROM OKE_K_HEADERS);
3937:
3938: CURSOR check_sts IS
3939: SELECT 'x' 3940: FROM OKC_STATUSES_B ST, OKC_K_HEADERS_B KH 3941: WHERE KH.ID = p_chr_id
3942: AND ST.CODE = KH.STS_CODE
3943: AND ST.STE_CODE not in ( 'ENTERED','CANCELLED');
3944: