APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_CLASS_OPERATIONS

Line 7: --| OKC_CLASS_OPERATIONS | X | | | | | |

3:
4: --+---------------------------------+---+---+---+---+---+----------------------+
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 |

Line 173: FROM okc_class_operations

169: p_opn_code VARCHAR2
170: )
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;

Line 1768: , okc_class_operations cls

1764: Function get_modifier(Contract_id Number) return varchar2 Is
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

Line 5598: okc_class_operations cls,

5594: IS
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'

Line 5614: okc_class_operations cls,

5610: IS
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'