APPS.OKC_CHR_PVT dependencies on OKC_SUBCLASSES_B

Line 945: FROM Okc_Subclasses_B

941: p_chrv_rec IN chrv_rec_type) IS
942: l_dummy_var VARCHAR2(1) := '?';
943: CURSOR l_scsv_csr (p_code IN VARCHAR2) IS
944: SELECT 'x'
945: FROM Okc_Subclasses_B
946: WHERE okc_subclasses_b.code = p_code;
947: BEGIN
948:
949: IF (l_debug = 'Y') THEN

Line 946: WHERE okc_subclasses_b.code = p_code;

942: l_dummy_var VARCHAR2(1) := '?';
943: CURSOR l_scsv_csr (p_code IN VARCHAR2) IS
944: SELECT 'x'
945: FROM Okc_Subclasses_B
946: WHERE okc_subclasses_b.code = p_code;
947: BEGIN
948:
949: IF (l_debug = 'Y') THEN
950: okc_debug.Set_Indentation('OKC_CHR_PVT');

Line 5303: FROM okc_classes_b cls, okc_subclasses_b scs

5299: ) RETURN VARCHAR2 IS
5300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5301: CURSOR l_app_csr(p_scs_code VARCHAR2) IS
5302: SELECT application_id
5303: FROM okc_classes_b cls, okc_subclasses_b scs
5304: WHERE cls.code = scs.cls_code
5305: AND scs.code = p_scs_code;
5306: BEGIN
5307: