DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on OKC_OPERATION_LINES

Line 1457: okc_operation_lines opl,

1453: OR (trunc(p_transaction_date) <= trunc(kl.start_date))
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')

Line 1507: okc_operation_lines opl,

1503: OR (trunc(p_transaction_date) <= trunc(kl.start_date))
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')

Line 1563: okc_operation_lines opl,

1559: OR (trunc(p_transaction_date) <= trunc(kl.start_date))
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')