APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_SUBCLASSES_B

Line 9: --| OKC_SUBCLASSES_B | X | | | | | |

5: --| OBJECT |SEL|INS|UPD|DEL|CRE|OTHER |
6: --+---------------------------------+---+---+---+---+---+----------------------+
7: --| OKC_CLASS_OPERATIONS | X | | | | | |
8: --+---------------------------------+---+---+---+---+---+----------------------+
9: --| OKC_SUBCLASSES_B | X | | | | | |
10: --+---------------------------------+---+---+---+---+---+----------------------+
11: --| OKC_OPER_INST_PVT | | | | | |X |
12: --+---------------------------------+---+---+---+---+---+----------------------+
13: --| OKS_STREAM_LEVELS_V | X | | | | | |

Line 175: FROM okc_subclasses_b

171: IS
172: SELECT ID
173: FROM okc_class_operations
174: WHERE cls_code = (SELECT cls_code
175: FROM okc_subclasses_b
176: WHERE code = 'SERVICE')
177: AND opn_code = p_opn_code;
178:
179:

Line 1769: , okc_subclasses_b sl

1765: Cursor l_renewal_csr Is
1766: SELECT object_chr_id
1767: FROM okc_operation_instances op
1768: , okc_class_operations cls
1769: , okc_subclasses_b sl
1770: , okc_operation_lines ol
1771: WHERE ol.subject_chr_id = contract_id
1772: And ol.subject_cle_id is null
1773: And op.id = ol.oie_id

Line 1910: okc_subclasses_b scs

1906: )
1907: IS
1908: SELECT application_id
1909: FROM okc_classes_b cls,
1910: okc_subclasses_b scs
1911: WHERE cls.code = scs.cls_code
1912: AND scs.code = p_scs_code;
1913:
1914: --Territory changes

Line 5599: okc_subclasses_b sl

5595: SELECT object_cle_id, OBJECT_CHR_ID
5596: FROM okc_operation_instances op,
5597: okc_operation_lines ol,
5598: okc_class_operations cls,
5599: okc_subclasses_b sl
5600: WHERE ol.oie_id = op.ID
5601: AND cls.cls_code = sl.cls_code
5602: And sl.code = 'SERVICE'
5603: And op.cop_id = cls.id

Line 5615: okc_subclasses_b sl

5611: SELECT ol.subject_cle_id, ol.subject_chr_id
5612: FROM okc_operation_instances op,
5613: okc_operation_lines ol,
5614: okc_class_operations cls,
5615: okc_subclasses_b sl
5616: WHERE ol.oie_id = op.ID
5617: AND cls.cls_code = sl.cls_code
5618: And sl.code = 'SERVICE'
5619: And op.cop_id = cls.id