APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_STREAM_LEVELS_B

Line 5435: FROM oks_stream_levels_b --okc_rules_b

5431: level_periods,
5432: uom_per_period,
5433: advance_periods,
5434: level_amount --rule_information6
5435: FROM oks_stream_levels_b --okc_rules_b
5436: WHERE dnz_chr_id = p_hdr_id
5437: AND cle_id = p_cle_id;
5438:
5439:

Line 5495: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;

5491: bill_action = 'RI';
5492:
5493: CURSOR sll_end_date_csr(l_cle_id NUMBER) IS
5494: SELECT MAX(end_date)
5495: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;
5496:
5497: CURSOR sll_start_date_csr(l_cle_id NUMBER) IS
5498: SELECT MIN(start_date)
5499: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;

Line 5499: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;

5495: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;
5496:
5497: CURSOR sll_start_date_csr(l_cle_id NUMBER) IS
5498: SELECT MIN(start_date)
5499: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;
5500:
5501: CURSOR check_lvl_element(l_cle_id NUMBER) IS
5502: SELECT amount FROM oks_level_elements
5503: WHERE nvl(amount, 0) < 0 AND

Line 5540: FROM oks_stream_levels_b -- okc_rules_b

5536: --Check for top line SLL exists
5537:
5538: SELECT COUNT(id)
5539: INTO l_top_line_SLL
5540: FROM oks_stream_levels_b -- okc_rules_b
5541: WHERE dnz_chr_id = p_chr_id
5542: AND cle_id = top_line_grp_rec.id;
5543:
5544:

Line 5787: FROM oks_stream_levels_b

5783: --Check for sub line SLL exists
5784:
5785: SELECT COUNT(id)
5786: INTO l_sub_line_SLL
5787: FROM oks_stream_levels_b
5788: WHERE dnz_chr_id = p_chr_id
5789: AND cle_id = line_grp_rec.id;
5790:
5791: