APPS.OKC_CONTRACT_PVT dependencies on OKC_SUBCLASSES_B

Line 4262: , okc_subclasses_b sl

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

Line 4371: , okc_subclasses_b sl

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

Line 4390: , okc_subclasses_b sl

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

Line 4417: , okc_subclasses_b sl

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

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

4511: start with id = p_cle_id;
4512:
4513: CURSOR l_k_code_csr IS
4514: SELECT cls_code from
4515: OKC_SUBCLASSES_B WHERE code=(SELECT scs_code from OKC_K_HEADERS_B where id in
4516: (select dnz_chr_id from okc_k_lines_b where id =p_cle_id));
4517:
4518: CURSOR l_chk_cle_csr IS
4519: SELECT clev.cle_id,RTRIM(clev.line_number) line_number,clev.lse_id