DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_CLASS_OPERATIONS

Line 4261: , okc_class_operations cls

4257: Cursor ole_csr Is
4258:
4259: SELECT distinct ol.object_chr_id
4260: FROM okc_operation_instances op
4261: , okc_class_operations cls
4262: , okc_subclasses_b sl
4263: , okc_operation_lines ol
4264: WHERE ol.subject_chr_id = p_target_chr_id
4265: And op.id = ol.oie_id

Line 4370: , okc_class_operations cls

4366: AND subject_cle_id is null
4367: AND object_cle_id is null
4368: And exists(Select 'x' --Fix Bug 4948793
4369: FROM okc_operation_instances op
4370: , okc_class_operations cls
4371: , okc_subclasses_b sl
4372: WHERE op.id = ol.oie_id
4373: AND op.cop_id = cls.id
4374: And cls.cls_code = sl.cls_code

Line 4389: , okc_class_operations cls

4385: last_update_date = sysdate,
4386: last_update_login = FND_GLOBAL.LOGIN_ID
4387: WHERE id in (Select ol.object_cle_id --Fix Bug 4948793
4388: FROM okc_operation_instances op
4389: , okc_class_operations cls
4390: , okc_subclasses_b sl
4391: , okc_operation_lines ol
4392: WHERE ol.subject_chr_id = p_target_chr_id
4393: And ol.object_cle_id is not null

Line 4416: , okc_class_operations cls

4412: AND subject_cle_id is not null
4413: AND object_cle_id is not null
4414: And exists(Select 'x' --Fix Bug 4948793
4415: FROM okc_operation_instances op
4416: , okc_class_operations cls
4417: , okc_subclasses_b sl
4418: WHERE op.id = ol.oie_id
4419: AND op.cop_id = cls.id
4420: And cls.cls_code = sl.cls_code