APPS.OKS_KHR_PVT dependencies on OKC_STATUSES_B

Line 1454: OKC_STATUSES_B sts

1450:
1451: CURSOR csr_check_entered (p_chr_id IN NUMBER) IS
1452: SELECT CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER, ORG_ID
1453: FROM OKC_K_HEADERS_ALL_B okck,
1454: OKC_STATUSES_B sts
1455: WHERE okck.id = p_chr_id
1456: AND sts.ste_code = 'ENTERED'
1457: AND NVL(TEMPLATE_YN, 'N') = 'N'
1458: AND sts.code = okck.sts_code;

Line 2474: OKC_STATUSES_B sts

2470:
2471: CURSOR csr_check_entered (p_chr_id IN NUMBER) IS
2472: SELECT ORG_ID
2473: FROM OKC_K_HEADERS_ALL_B okck,
2474: OKC_STATUSES_B sts
2475: WHERE okck.id = p_chr_id
2476: AND sts.ste_code = 'ENTERED'
2477: AND NVL(TEMPLATE_YN, 'N') = 'N'
2478: AND sts.code = okck.sts_code;