APPS.OKS_KHR_PVT dependencies on OKC_STATUSES_B

Line 1478: OKC_STATUSES_B sts

1474:
1475: CURSOR csr_check_entered (p_chr_id IN NUMBER) IS
1476: SELECT CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER, ORG_ID
1477: FROM OKC_K_HEADERS_ALL_B okck,
1478: OKC_STATUSES_B sts
1479: WHERE okck.id = p_chr_id
1480: AND sts.ste_code = 'ENTERED'
1481: AND NVL(TEMPLATE_YN, 'N') = 'N'
1482: AND sts.code = okck.sts_code;

Line 2504: OKC_STATUSES_B sts

2500:
2501: CURSOR csr_check_entered (p_chr_id IN NUMBER) IS
2502: SELECT ORG_ID
2503: FROM OKC_K_HEADERS_ALL_B okck,
2504: OKC_STATUSES_B sts
2505: WHERE okck.id = p_chr_id
2506: AND sts.ste_code = 'ENTERED'
2507: AND NVL(TEMPLATE_YN, 'N') = 'N'
2508: AND sts.code = okck.sts_code;