APPS.OKC_KSQ_PVT dependencies on OKC_SUBCLASSES_B

Line 2358: from okc_subclasses_b

2354: where line_code = p_line_code;
2355:
2356: cursor csr_cls is
2357: select cls_code
2358: from okc_subclasses_b
2359: where code = p_scs_code;
2360:
2361: -- l_bug Number(15) := Sys_Context('OKC_CONTEXT', 'BUSINESS_GROUP_ID');
2362: -- l_opu Number(15) := Sys_Context('OKC_CONTEXT', 'ORG_ID');

Line 2375: l_cls_code okc_subclasses_b.cls_code%TYPE;

2371: FROM HR_ALL_ORGANIZATION_UNITS
2372: WHERE ORGANIZATION_ID = V_ORG_ID;
2373: --end npalepu
2374:
2375: l_cls_code okc_subclasses_b.cls_code%TYPE;
2376: l_row_notfound Boolean;
2377:
2378: Function cls_scs_found (i number) Return Boolean is
2379: l_found Boolean := False;