DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on OKC_OPERATION_INSTANCES

Line 1456: from okc_operation_instances ois,

1452: And ( (trunc(p_transaction_date) <= trunc(KL.end_date)And trunc(p_transaction_date) >= trunc(KL.start_date))
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

Line 1506: from okc_operation_instances ois,

1502: And ( (trunc(p_transaction_date) <= trunc(KL.end_date)And trunc(p_transaction_date) >= trunc(KL.start_date))
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

Line 1562: from okc_operation_instances ois,

1558: And ( (trunc(p_transaction_date) <= trunc(KL.end_date)And trunc(p_transaction_date) >= trunc(KL.start_date))
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