APPS.OKS_IBINT_PUB dependencies on OKC_OPERATION_INSTANCES

Line 1298: from okc_operation_instances ois,

1294: OR (trunc(tmp.transfer_date) <= trunc(kl.start_date))
1295: OR ( trunc(KL.end_date) < trunc(tmp.transfer_date)
1296: And kl.lse_id <> 18
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

Line 1400: from okc_operation_instances ois,

1396: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1397: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1398: And kl.lse_id <> 18
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

Line 1505: from okc_operation_instances ois,

1501: And trunc(tmp.Termination_date) >= trunc(KL.start_date))
1502: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1503: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
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

Line 1604: from okc_operation_instances ois,

1600: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1601: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1602: And kl.lse_id <> 18
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

Line 1707: from okc_operation_instances ois,

1703: And trunc(tmp.Termination_date) >= trunc(KL.start_date))
1704: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1705: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
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

Line 3206: from okc_operation_instances ois,

3202: And KH.template_yn = 'N'
3203: AND (( cl.end_date >= p_transaction_date) OR
3204: (cl.end_date < p_transaction_date
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

Line 3236: from okc_operation_instances ois,

3232: And KH.template_yn = 'N'
3233: AND (( cl.end_date >= p_transaction_date) OR
3234: (cl.end_date < p_transaction_date
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

Line 3272: from okc_operation_instances ois,

3268: And CL.date_terminated Is Null
3269: AND (( cl.end_date >= p_transaction_date) OR
3270: (cl.end_date < p_transaction_date
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

Line 3305: from okc_operation_instances ois,

3301: And CL.date_terminated Is Null
3302: AND (( cl.end_date >= p_transaction_date) OR
3303: (cl.end_date < p_transaction_date
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