APPS.OKS_BILL_MIGRATION dependencies on OKC_K_REL_OBJS

Line 375: and ( exists ( select 1 from okc_k_rel_objs rel

371: cursor l_check_mig_csr is
372: select 'x'
373: FROM okc_k_lines_b lines
374: where lines.lse_id = 19
375: and ( exists ( select 1 from okc_k_rel_objs rel
376: where rel.cle_id = lines.id )
377: or
378: exists ( select 1 from okc_k_rel_objs rel2 ,
379: okc_k_lines_b line2

Line 378: exists ( select 1 from okc_k_rel_objs rel2 ,

374: where lines.lse_id = 19
375: and ( exists ( select 1 from okc_k_rel_objs rel
376: where rel.cle_id = lines.id )
377: or
378: exists ( select 1 from okc_k_rel_objs rel2 ,
379: okc_k_lines_b line2
380: where line2.cle_id = lines.id
381: and rel2.cle_id = line2.id
382: and line2.lse_id = 25 )

Line 1276: and ( exists ( select 1 from okc_k_rel_objs rel

1272: and lines.lse_id = 19
1273: and lines.dnz_chr_id = hdr.id
1274: and lines.sts_code <> 'TERMINATED'
1275: AND ( nvl(lines.upg_orig_system_ref,'x') <> 'MIG_BILL' )
1276: and ( exists ( select 1 from okc_k_rel_objs rel
1277: where rel.cle_id = lines.id )
1278: or
1279: exists ( select 1 from okc_k_rel_objs rel2 ,
1280: okc_k_lines_b line2

Line 1279: exists ( select 1 from okc_k_rel_objs rel2 ,

1275: AND ( nvl(lines.upg_orig_system_ref,'x') <> 'MIG_BILL' )
1276: and ( exists ( select 1 from okc_k_rel_objs rel
1277: where rel.cle_id = lines.id )
1278: or
1279: exists ( select 1 from okc_k_rel_objs rel2 ,
1280: okc_k_lines_b line2
1281: where line2.cle_id = lines.id
1282: and rel2.cle_id = line2.id
1283: and line2.lse_id = 25 ) );

Line 1429: and not exists ( select 1 from okc_k_rel_objs rel

1425: AND lines.sts_code not in ('TERMINATED','ENTERED','CANCELLED')
1426: and lines.dnz_chr_id = rgp.dnz_chr_id
1427: AND lines.dnz_chr_id between P_chr_id_lo and p_chr_id_hi
1428: AND (( lines.upg_orig_system_ref IS NULL
1429: and not exists ( select 1 from okc_k_rel_objs rel
1430: where rel.cle_id = lines.id and rownum < 2 ) )
1431: OR ( nvl(lines.upg_orig_system_ref,'MIG_NOBILL') = 'MIG_BILL'))
1432: AND NOT EXISTS
1433: (SELECT 1 FROM oks_stream_levels_b sll

Line 1474: and not exists ( select 1 from okc_k_rel_objs rel

1470: lines.date_terminated
1471: FROM okc_k_lines_b lines
1472: WHERE lines.cle_id = p_cle_id
1473: AND lines.lse_id in (7,8,9,10,11,13,18,25,35)
1474: and not exists ( select 1 from okc_k_rel_objs rel
1475: where rel.cle_id = lines.id );
1476:
1477:
1478: --Rule information for top line

Line 2084: FROM OKC_K_REL_OBJS

2080: WHERE CLE_ID = P_CLE_ID ;
2081:
2082: CURSOR L_GET_ORDER_NUMBER_CSR ( P_SUB_LINE_ID NUMBER ) IS
2083: SELECT OBJECT1_ID1
2084: FROM OKC_K_REL_OBJS
2085: WHERE CLE_ID = P_SUB_LINE_ID ;
2086:
2087:
2088: L_LINES_REC L_LINES_CSR%ROWTYPE ;