DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_CLASS_OPERATIONS

Line 4319: , okc_class_operations cls

4315: Cursor ole_csr Is
4316:
4317: SELECT distinct ol.object_chr_id
4318: FROM okc_operation_instances op
4319: , okc_class_operations cls
4320: , okc_subclasses_b sl
4321: , okc_operation_lines ol
4322: WHERE ol.subject_chr_id = p_target_chr_id
4323: And op.id = ol.oie_id

Line 4428: , okc_class_operations cls

4424: AND subject_cle_id is null
4425: AND object_cle_id is null
4426: And exists(Select 'x' --Fix Bug 4948793
4427: FROM okc_operation_instances op
4428: , okc_class_operations cls
4429: , okc_subclasses_b sl
4430: WHERE op.id = ol.oie_id
4431: AND op.cop_id = cls.id
4432: And cls.cls_code = sl.cls_code

Line 4447: , okc_class_operations cls

4443: last_update_date = sysdate,
4444: last_update_login = FND_GLOBAL.LOGIN_ID
4445: WHERE id in (Select ol.object_cle_id --Fix Bug 4948793
4446: FROM okc_operation_instances op
4447: , okc_class_operations cls
4448: , okc_subclasses_b sl
4449: , okc_operation_lines ol
4450: WHERE ol.subject_chr_id = p_target_chr_id
4451: And ol.object_cle_id is not null

Line 4474: , okc_class_operations cls

4470: AND subject_cle_id is not null
4471: AND object_cle_id is not null
4472: And exists(Select 'x' --Fix Bug 4948793
4473: FROM okc_operation_instances op
4474: , okc_class_operations cls
4475: , okc_subclasses_b sl
4476: WHERE op.id = ol.oie_id
4477: AND op.cop_id = cls.id
4478: And cls.cls_code = sl.cls_code