APPS.OKC_QP_UPGRADE_PUB dependencies on OKC_CLASSES_B

Line 1211: okc_classes_b cs

1207: -- category cursor for all/ specific categories in OKC and OKO
1208: CURSOR csr_category IS
1209: SELECT scs.code
1210: FROM okc_subclasses_b scs,
1211: okc_classes_b cs
1212: WHERE scs.cls_code = cs.code
1213: AND cs.application_id IN (510,871)
1214: AND scs.code = NVL(p_category_code,scs.code) ;
1215:

Line 1411: FROM okc_subclasses_b scs, okc_classes_b cs

1407: l_categories_done number(9);
1408:
1409: CURSOR csr_total_categories IS
1410: SELECT COUNT(scs.code)
1411: FROM okc_subclasses_b scs, okc_classes_b cs
1412: WHERE scs.cls_code = cs.code
1413: AND cs.application_id IN ( 510, 871 );
1414:
1415: CURSOR csr_categories_done IS

Line 1683: FROM okc_subclasses_v scs, okc_classes_b cs

1679: ORDER BY scs.meaning;
1680:
1681: CURSOR category_pending_csr IS
1682: SELECT scs.meaning
1683: FROM okc_subclasses_v scs, okc_classes_b cs
1684: WHERE scs.cls_code = cs.code
1685: AND cs.application_id IN (510,871)
1686: AND scs.code NOT IN (
1687: SELECT scs_code