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 1765: , okc_subclasses_b sl

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

Line 1905: okc_subclasses_b scs

1901: )
1902: IS
1903: SELECT application_id
1904: FROM okc_classes_b cls,
1905: okc_subclasses_b scs
1906: WHERE cls.code = scs.cls_code
1907: AND scs.code = p_scs_code;
1908:
1909: --Territory changes

Line 5582: okc_subclasses_b sl

5578: SELECT object_cle_id, OBJECT_CHR_ID
5579: FROM okc_operation_instances op,
5580: okc_operation_lines ol,
5581: okc_class_operations cls,
5582: okc_subclasses_b sl
5583: WHERE ol.oie_id = op.ID
5584: AND cls.cls_code = sl.cls_code
5585: And sl.code = 'SERVICE'
5586: And op.cop_id = cls.id

Line 5598: okc_subclasses_b sl

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