APPS.OKS_IBINT_PUB dependencies on OKC_OPERATION_INSTANCES

Line 1278: from okc_operation_instances ois,

1274: OR (trunc(tmp.transfer_date) <= trunc(kl.start_date))
1275: OR ( trunc(KL.end_date) < trunc(tmp.transfer_date)
1276: And kl.lse_id <> 18
1277: And not exists (Select 'x'
1278: from okc_operation_instances ois,
1279: okc_operation_lines opl,
1280: okc_class_operations cls,
1281: okc_subclasses_b sl
1282: where ois.id=opl.oie_id

Line 1380: from okc_operation_instances ois,

1376: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1377: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1378: And kl.lse_id <> 18
1379: And not exists (Select 'x'
1380: from okc_operation_instances ois,
1381: okc_operation_lines opl,
1382: okc_class_operations cls,
1383: okc_subclasses_b sl
1384: where ois.id=opl.oie_id

Line 1485: from okc_operation_instances ois,

1481: And trunc(tmp.Termination_date) >= trunc(KL.start_date))
1482: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1483: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1484: And not exists (Select 'x'
1485: from okc_operation_instances ois,
1486: okc_operation_lines opl,
1487: okc_class_operations cls,
1488: okc_subclasses_b sl
1489: where ois.id=opl.oie_id

Line 1584: from okc_operation_instances ois,

1580: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1581: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1582: And kl.lse_id <> 18
1583: And not exists (Select 'x'
1584: from okc_operation_instances ois,
1585: okc_operation_lines opl,
1586: okc_class_operations cls,
1587: okc_subclasses_b sl
1588: where ois.id=opl.oie_id

Line 1687: from okc_operation_instances ois,

1683: And trunc(tmp.Termination_date) >= trunc(KL.start_date))
1684: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1685: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1686: And not exists (Select 'x'
1687: from okc_operation_instances ois,
1688: okc_operation_lines opl,
1689: okc_class_operations cls,
1690: okc_subclasses_b sl
1691: where ois.id=opl.oie_id

Line 3174: from okc_operation_instances ois,

3170: And KH.template_yn = 'N'
3171: AND (( cl.end_date >= p_transaction_date) OR
3172: (cl.end_date < p_transaction_date
3173: and not exists (Select 'x'
3174: from okc_operation_instances ois,
3175: okc_operation_lines opl,
3176: okc_class_operations cls,
3177: okc_subclasses_b sl
3178: where ois.id=opl.oie_id

Line 3204: from okc_operation_instances ois,

3200: And KH.template_yn = 'N'
3201: AND (( cl.end_date >= p_transaction_date) OR
3202: (cl.end_date < p_transaction_date
3203: and not exists (Select 'x'
3204: from okc_operation_instances ois,
3205: okc_operation_lines opl,
3206: okc_class_operations cls,
3207: okc_subclasses_b sl
3208: where ois.id=opl.oie_id

Line 3240: from okc_operation_instances ois,

3236: And CL.date_terminated Is Null
3237: AND (( cl.end_date >= p_transaction_date) OR
3238: (cl.end_date < p_transaction_date
3239: and not exists (select 'x'
3240: from okc_operation_instances ois,
3241: okc_operation_lines opl,
3242: okc_class_operations cls,
3243: okc_subclasses_b sl
3244: where ois.id=opl.oie_id

Line 3273: from okc_operation_instances ois,

3269: And CL.date_terminated Is Null
3270: AND (( cl.end_date >= p_transaction_date) OR
3271: (cl.end_date < p_transaction_date
3272: and not exists (select 'x'
3273: from okc_operation_instances ois,
3274: okc_operation_lines opl,
3275: okc_class_operations cls,
3276: okc_subclasses_b sl
3277: where ois.id=opl.oie_id