APPS.OKS_IBINT_PUB dependencies on OKC_SUBCLASSES_B

Line 1301: okc_subclasses_b sl

1297: And not exists (Select 'x'
1298: from okc_operation_instances ois,
1299: okc_operation_lines opl,
1300: okc_class_operations cls,
1301: okc_subclasses_b sl
1302: where ois.id=opl.oie_id
1303: And cls.opn_code in ('RENEWAL','REN_CON')
1304: And sl.code= 'SERVICE'
1305: And sl.cls_code = cls.cls_code

Line 1403: okc_subclasses_b sl

1399: And not exists (Select 'x'
1400: from okc_operation_instances ois,
1401: okc_operation_lines opl,
1402: okc_class_operations cls,
1403: okc_subclasses_b sl
1404: where ois.id=opl.oie_id
1405: And cls.opn_code in ('RENEWAL','REN_CON')
1406: And sl.code= 'SERVICE'
1407: And sl.cls_code = cls.cls_code

Line 1508: okc_subclasses_b sl

1504: And not exists (Select 'x'
1505: from okc_operation_instances ois,
1506: okc_operation_lines opl,
1507: okc_class_operations cls,
1508: okc_subclasses_b sl
1509: where ois.id=opl.oie_id
1510: And cls.opn_code in ('RENEWAL','REN_CON')
1511: And sl.code= 'SERVICE'
1512: And sl.cls_code = cls.cls_code

Line 1607: okc_subclasses_b sl

1603: And not exists (Select 'x'
1604: from okc_operation_instances ois,
1605: okc_operation_lines opl,
1606: okc_class_operations cls,
1607: okc_subclasses_b sl
1608: where ois.id=opl.oie_id
1609: And cls.opn_code in ('RENEWAL','REN_CON')
1610: And sl.code= 'SERVICE'
1611: And sl.cls_code = cls.cls_code

Line 1710: okc_subclasses_b sl

1706: And not exists (Select 'x'
1707: from okc_operation_instances ois,
1708: okc_operation_lines opl,
1709: okc_class_operations cls,
1710: okc_subclasses_b sl
1711: where ois.id=opl.oie_id
1712: And cls.opn_code in ('RENEWAL','REN_CON')
1713: And sl.code= 'SERVICE'
1714: And sl.cls_code = cls.cls_code

Line 3209: okc_subclasses_b sl

3205: and not exists (Select 'x'
3206: from okc_operation_instances ois,
3207: okc_operation_lines opl,
3208: okc_class_operations cls,
3209: okc_subclasses_b sl
3210: where ois.id=opl.oie_id
3211: And cls.opn_code in ('RENEWAL','REN_CON')
3212: And sl.code= 'SERVICE'
3213: And sl.cls_code = cls.cls_code

Line 3239: okc_subclasses_b sl

3235: and not exists (Select 'x'
3236: from okc_operation_instances ois,
3237: okc_operation_lines opl,
3238: okc_class_operations cls,
3239: okc_subclasses_b sl
3240: where ois.id=opl.oie_id
3241: And cls.opn_code in ('RENEWAL','REN_CON')
3242: And sl.code= 'SERVICE'
3243: And sl.cls_code = cls.cls_code

Line 3275: okc_subclasses_b sl

3271: and not exists (select 'x'
3272: from okc_operation_instances ois,
3273: okc_operation_lines opl,
3274: okc_class_operations cls,
3275: okc_subclasses_b sl
3276: where ois.id=opl.oie_id
3277: And cls.opn_code in ('RENEWAL','REN_CON')
3278: And sl.code= 'SERVICE'
3279: And sl.cls_code = cls.cls_code

Line 3308: okc_subclasses_b sl

3304: and not exists (select 'x'
3305: from okc_operation_instances ois,
3306: okc_operation_lines opl,
3307: okc_class_operations cls,
3308: okc_subclasses_b sl
3309: where ois.id=opl.oie_id
3310: And cls.opn_code in ('RENEWAL','REN_CON')
3311: And sl.code= 'SERVICE'
3312: And sl.cls_code = cls.cls_code