APPS.OKC_QP_UPGRADE_PUB dependencies on OKC_SUBCLASSES_V

Line 1667: FROM okc_subclasses_v scs, okc_qp_upgrade qp

1663: CURSOR category_compeleted_csr IS
1664: SELECT RPAD(scs.meaning,40),
1665: RPAD(qp.CREATION_DATE,13),
1666: qp.LAST_UPDATE_DATE
1667: FROM okc_subclasses_v scs, okc_qp_upgrade qp
1668: WHERE qp.scs_code = scs.code
1669: AND qp.line_type = 'CATEGORY'
1670: AND qp.completion_flag = 'Y'
1671: ORDER BY scs.meaning;

Line 1675: FROM okc_subclasses_v scs, okc_qp_upgrade qp

1671: ORDER BY scs.meaning;
1672:
1673: CURSOR category_incompeleted_csr IS
1674: SELECT scs.meaning
1675: FROM okc_subclasses_v scs, okc_qp_upgrade qp
1676: WHERE qp.scs_code = scs.code
1677: AND qp.line_type = 'CATEGORY'
1678: AND qp.completion_flag = 'N'
1679: ORDER BY scs.meaning;

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