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 1764: , okc_class_operations cls

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

Line 5581: okc_class_operations cls,

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

Line 5597: okc_class_operations cls,

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