APPS.OKE_CONTRACT_PUB dependencies on OKE_K_TYPES_B
Line 3935: AND K_TYPE_CODE IN (SELECT K_TYPE_CODE FROM OKE_K_TYPES_B WHERE TYPE_CLASS_CODE='BOA')
3931: CURSOR check_boa IS
3932: SELECT 'x'
3933: FROM OKE_K_HEADERS
3934: WHERE K_HEADER_ID = p_chr_id 3935: AND K_TYPE_CODE IN (SELECT K_TYPE_CODE FROM OKE_K_TYPES_B WHERE TYPE_CLASS_CODE='BOA') 3936: AND K_HEADER_ID IN (SELECT BOA_ID FROM OKE_K_HEADERS);
3937:
3938: CURSOR check_sts IS
3939: SELECT 'x'