DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on OKC_CLASS_OPERATIONS

Line 1458: okc_class_operations cls,

1454: OR ( trunc(KL.end_date) < trunc(p_transaction_date) and Kl.lse_id <> 18
1455: And not exists (Select 'x'
1456: from okc_operation_instances ois,
1457: okc_operation_lines opl,
1458: okc_class_operations cls,
1459: okc_subclasses_b sl
1460: where ois.id=opl.oie_id
1461: And cls.opn_code in ('RENEWAL','REN_CON')
1462: And sl.code= 'SERVICE'

Line 1508: okc_class_operations cls,

1504: OR ( trunc(KL.end_date) < trunc(p_transaction_date) and Kl.lse_id <> 18
1505: And not exists (Select 'x'
1506: from okc_operation_instances ois,
1507: okc_operation_lines opl,
1508: okc_class_operations cls,
1509: okc_subclasses_b sl
1510: where ois.id=opl.oie_id
1511: And cls.opn_code in ('RENEWAL','REN_CON')
1512: And sl.code= 'SERVICE'

Line 1564: okc_class_operations cls,

1560: OR ( trunc(KL.end_date) < trunc(p_transaction_date)
1561: And not exists (Select 'x'
1562: from okc_operation_instances ois,
1563: okc_operation_lines opl,
1564: okc_class_operations cls,
1565: okc_subclasses_b sl
1566: where ois.id=opl.oie_id
1567: And cls.opn_code in ('RENEWAL','REN_CON')
1568: And sl.code= 'SERVICE'