APPS.OKE_CONTRACT_PUB dependencies on OKE_K_TYPES_B

Line 3937: AND K_TYPE_CODE IN (SELECT K_TYPE_CODE FROM OKE_K_TYPES_B WHERE TYPE_CLASS_CODE='BOA')

3933: CURSOR check_boa IS
3934: SELECT 'x'
3935: FROM OKE_K_HEADERS
3936: WHERE K_HEADER_ID = p_chr_id
3937: AND K_TYPE_CODE IN (SELECT K_TYPE_CODE FROM OKE_K_TYPES_B WHERE TYPE_CLASS_CODE='BOA')
3938: AND K_HEADER_ID IN (SELECT BOA_ID FROM OKE_K_HEADERS);
3939:
3940: CURSOR check_sts IS
3941: SELECT 'x'