APPS.OKC_CONTRACT_PVT dependencies on OKC_OPERATION_INSTANCES

Line 942: FROM okc_operation_instances

938: WHERE chr_id = p_chrv_rec.id;
939:
940: Cursor oie_csr Is
941: SELECT id
942: FROM okc_operation_instances
943: WHERE target_chr_id = p_chrv_rec.id;
944:
945: Cursor l_scrv_csr Is --sales credit
946: SELECT id, object_version_number, dnz_chr_id

Line 4260: FROM okc_operation_instances op

4256: --Fix for bug 4948793
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

Line 4369: FROM okc_operation_instances op

4365: WHERE subject_chr_id = p_target_chr_id
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

Line 4388: FROM okc_operation_instances op

4384: last_updated_by = FND_GLOBAL.USER_ID,
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

Line 4415: FROM okc_operation_instances op

4411: WHERE subject_chr_id = p_target_chr_id
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