DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 1477: FROM OKC_K_HEADERS_ALL_B okck,

1473: -- HANDCODED FOR PROCESS WORKFLOW
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'

Line 2503: FROM OKC_K_HEADERS_ALL_B okck,

2499: -- HANDCODED FOR PROCESS WORKFLOW
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'