APPS.OKS_BILL_MIGRATION dependencies on OKS_STREAM_LEVELS_B

Line 284: FROM OKS_STREAM_LEVELS_B;

280: --Newly added cursor to check whether migration has already happened.
281: ---------------------------------------------------------------------
282: cursor l_check_mig_csr is
283: SELECT 'x'
284: FROM OKS_STREAM_LEVELS_B;
285:
286:
287:
288: l_agg_rec l_header_agg_csr%ROWTYPE;

Line 753: FROM oks_level_elements lvl,oks_stream_levels_b rule

749: CURSOR level_elements_csr (p_id NUMBER) IS
750: SELECT lvl.id id, lvl.sequence_number sequence_number,
751: lvl.date_start date_start, lvl.amount amount,
752: lvl.date_completed date_completed
753: FROM oks_level_elements lvl,oks_stream_levels_b rule
754: WHERE lvl.rul_id = rule.id
755: AND rule.cle_id = p_id
756: ORDER BY lvl.date_start;
757:

Line 1170: INSERT INTO OKS_STREAM_LEVELS_B

1166:
1167: Begin
1168: l_top_line_sll_id := get_seq_id ;
1169:
1170: INSERT INTO OKS_STREAM_LEVELS_B
1171: (id, chr_id, cle_id,dnz_chr_id , sequence_no, uom_code , start_date, end_date,
1172: level_periods, uom_per_period, object_version_number,
1173: created_by , creation_date, last_updated_by, last_update_date )
1174: VALUES

Line 1200: INSERT INTO OKS_STREAM_LEVELS_B

1196: loop
1197: l_sub_line_sll_id := get_seq_id ;
1198:
1199:
1200: INSERT INTO OKS_STREAM_LEVELS_B
1201: (id, chr_id, cle_id,dnz_chr_id , sequence_no, uom_code , start_date, end_date,
1202: level_periods, uom_per_period, object_version_number,
1203: created_by , creation_date, last_updated_by, last_update_date )
1204: VALUES(l_sub_line_sll_id, null, l_sub_line_rec.sub_line_id, p_chr_id, 1, 'DAY', p_srv_sdt, p_srv_edt,

Line 1287: FROM OKS_STREAM_LEVELS_B

1283: and line2.lse_id = 25 ) );
1284:
1285: CURSOR l_sll_csr(p_top_line_id NUMBER) IS
1286: SELECT COUNT(id)
1287: FROM OKS_STREAM_LEVELS_B
1288: WHERE CLE_ID = p_top_line_id;
1289:
1290: L_SLL_COUNT NUMBER;
1291:

Line 1433: (SELECT 1 FROM oks_stream_levels_b sll

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
1434: WHERE sll.cle_id = lines.id )
1435: AND rul.rgp_id(+) = rgp.id
1436: AND rul.rule_information_category(+) = 'IRE';
1437:

Line 1459: FROM oks_level_elements lvl, oks_stream_levels_b rule

1455: CURSOR level_elements_csr (p_id NUMBER) IS
1456: SELECT lvl.id id, lvl.sequence_number sequence_number,
1457: lvl.date_start date_start, lvl.amount amount,
1458: lvl.date_completed date_completed
1459: FROM oks_level_elements lvl, oks_stream_levels_b rule
1460: WHERE lvl.rul_id = rule.id
1461: AND rule.cle_id = p_id
1462: ORDER BY lvl.date_start;
1463: