APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_CLASS_OPERATIONS

Line 567: from okc_class_operations clsop

563: INTO g_renewal_id,g_ren_con_id
564: from
565: (
566: SELECT decode(opn_code,'RENEWAL',id,null) Renewal_ID, decode(opn_code,'REN_CON',id,null) Ren_CON_ID
567: from okc_class_operations clsop
568: WHERE clsop.cls_code='SERVICE'
569: AND clsop.opn_code in ('RENEWAL','REN_CON')
570: );
571:

Line 1081: from okc_class_operations clsop

1077: INTO g_renewal_id,g_ren_con_id
1078: from
1079: (
1080: SELECT decode(opn_code,'RENEWAL',id,null) Renewal_ID, decode(opn_code,'REN_CON',id,null) Ren_CON_ID
1081: from okc_class_operations clsop
1082: WHERE clsop.cls_code='SERVICE'
1083: AND clsop.opn_code in ('RENEWAL','REN_CON')
1084: );
1085:

Line 2258: from okc_class_operations clsop

2254: INTO g_renewal_id,g_ren_con_id
2255: from
2256: (
2257: SELECT decode(opn_code,'RENEWAL',id,null) Renewal_ID, decode(opn_code,'REN_CON',id,null) Ren_CON_ID
2258: from okc_class_operations clsop
2259: WHERE clsop.cls_code='SERVICE'
2260: AND clsop.opn_code in ('RENEWAL','REN_CON')
2261: );
2262:

Line 3034: OKC_CLASS_OPERATIONS CLSOP

3030: , MAX(rel.subject_cle_id) KEEP (DENSE_RANK LAST
3031: ORDER BY rel.last_update_date) r_cle_id
3032: FROM OKC_OPERATION_LINES REL ,
3033: OKC_OPERATION_INSTANCES OPINS,
3034: OKC_CLASS_OPERATIONS CLSOP
3035: WHERE 1 = 1
3036: AND rel.oie_id=opins.id
3037: AND opins.cop_id=clsop.id
3038: AND clsop.cls_code='SERVICE'

Line 3099: okc_class_operations clsop

3095: , MAX (rel.subject_cle_id)KEEP (DENSE_RANK LAST ORDER BY rel.last_update_date) r_cle_id
3096: FROM oki_dbi_ren_inc b,
3097: okc_operation_lines rel
3098: ,okc_operation_instances opins,
3099: okc_class_operations clsop
3100: WHERE 1 = 1
3101: AND rel.oie_id=opins.id
3102: AND opins.cop_id=clsop.id
3103: AND clsop.cls_code='SERVICE'

Line 3155: , okc_class_operations clsop

3151: FROM oki_dbi_cle_del del1
3152: , oki_dbi_cle_b del
3153: , okc_operation_lines rl
3154: , okc_operation_instances opins
3155: , okc_class_operations clsop
3156: WHERE 1 = 1
3157: AND rl.oie_id=opins.id
3158: AND opins.cop_id=clsop.id
3159: AND clsop.cls_code='SERVICE'