APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_STREAM_LEVELS_B

Line 5582: FROM oks_stream_levels_b --okc_rules_b

5578: level_periods,
5579: uom_per_period,
5580: advance_periods,
5581: level_amount --rule_information6
5582: FROM oks_stream_levels_b --okc_rules_b
5583: WHERE dnz_chr_id = p_hdr_id
5584: AND cle_id = p_cle_id;
5585:
5586:

Line 5642: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;

5638: bill_action = 'RI';
5639:
5640: CURSOR sll_end_date_csr(l_cle_id NUMBER) IS
5641: SELECT MAX(end_date)
5642: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;
5643:
5644: CURSOR sll_start_date_csr(l_cle_id NUMBER) IS
5645: SELECT MIN(start_date)
5646: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;

Line 5646: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;

5642: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;
5643:
5644: CURSOR sll_start_date_csr(l_cle_id NUMBER) IS
5645: SELECT MIN(start_date)
5646: FROM oks_stream_levels_b WHERE cle_id = l_cle_id;
5647:
5648: CURSOR check_lvl_element(l_cle_id NUMBER) IS
5649: SELECT amount FROM oks_level_elements
5650: WHERE nvl(amount, 0) < 0 AND

Line 5687: FROM oks_stream_levels_b -- okc_rules_b

5683: --Check for top line SLL exists
5684:
5685: SELECT COUNT(id)
5686: INTO l_top_line_SLL
5687: FROM oks_stream_levels_b -- okc_rules_b
5688: WHERE dnz_chr_id = p_chr_id
5689: AND cle_id = top_line_grp_rec.id;
5690:
5691:

Line 5934: FROM oks_stream_levels_b

5930: --Check for sub line SLL exists
5931:
5932: SELECT COUNT(id)
5933: INTO l_sub_line_SLL
5934: FROM oks_stream_levels_b
5935: WHERE dnz_chr_id = p_chr_id
5936: AND cle_id = line_grp_rec.id;
5937:
5938: