APPS.OKC_CONTRACT_PVT dependencies on OKC_SUBCLASSES_B

Line 4320: , okc_subclasses_b sl

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
4324: AND op.cop_id = cls.id

Line 4429: , okc_subclasses_b sl

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
4433: And sl.code = 'SERVICE'

Line 4448: , okc_subclasses_b sl

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
4452: And op.id = ol.oie_id

Line 4475: , okc_subclasses_b sl

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
4479: And sl.code = 'SERVICE'

Line 4573: OKC_SUBCLASSES_B WHERE code=(SELECT scs_code from OKC_K_HEADERS_B where id in

4569: start with id = p_cle_id;
4570:
4571: CURSOR l_k_code_csr IS
4572: SELECT cls_code from
4573: OKC_SUBCLASSES_B WHERE code=(SELECT scs_code from OKC_K_HEADERS_B where id in
4574: (select dnz_chr_id from okc_k_lines_b where id =p_cle_id));
4575:
4576: CURSOR l_chk_cle_csr IS
4577: SELECT clev.cle_id,RTRIM(clev.line_number) line_number,clev.lse_id