APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_LEVEL_ELEMENTS

Line 2991: FROM oks_level_elements

2987: -- select date transaction
2988:
2989: CURSOR trx_date_csr(l_cle_id IN NUMBER) IS
2990: SELECT MAX(date_transaction)
2991: FROM oks_level_elements
2992: WHERE parent_cle_id = l_cle_id;
2993:
2994:
2995: -- GCHADHA --

Line 5592: FROM oks_level_elements

5588:
5589: CURSOR level_elements_csr (p_id NUMBER) IS
5590: SELECT date_start, date_transaction, date_to_interface,
5591: amount, date_completed
5592: FROM oks_level_elements
5593: WHERE rul_id = p_id -- is the id in oks_level_elements
5594: AND date_completed IS NULL
5595: ORDER BY date_start; -- Added for bug# 2517147
5596:

Line 5593: WHERE rul_id = p_id -- is the id in oks_level_elements

5589: CURSOR level_elements_csr (p_id NUMBER) IS
5590: SELECT date_start, date_transaction, date_to_interface,
5591: amount, date_completed
5592: FROM oks_level_elements
5593: WHERE rul_id = p_id -- is the id in oks_level_elements
5594: AND date_completed IS NULL
5595: ORDER BY date_start; -- Added for bug# 2517147
5596:
5597: --Level element information - to check amount and periods

Line 5601: FROM oks_level_elements

5597: --Level element information - to check amount and periods
5598:
5599: CURSOR level_elements_amt_csr (p_id NUMBER) IS
5600: SELECT COUNT(rul_id) lvl_count, SUM(amount) lvl_amt
5601: FROM oks_level_elements
5602: WHERE rul_id = p_id -- is the id in oks_level_elements
5603: GROUP BY rul_id;
5604:
5605: --get rle information E/T/P of top line

Line 5602: WHERE rul_id = p_id -- is the id in oks_level_elements

5598:
5599: CURSOR level_elements_amt_csr (p_id NUMBER) IS
5600: SELECT COUNT(rul_id) lvl_count, SUM(amount) lvl_amt
5601: FROM oks_level_elements
5602: WHERE rul_id = p_id -- is the id in oks_level_elements
5603: GROUP BY rul_id;
5604:
5605: --get rle information E/T/P of top line
5606: -- SLH rule

Line 5615: FROM oks_level_elements

5611: AND cle_id = p_cle_id;
5612:
5613: CURSOR level_elements_billed_csr (p_id NUMBER) IS
5614: SELECT SUM(amount) billed_amt
5615: FROM oks_level_elements
5616: WHERE rul_id = p_id
5617: AND date_completed IS NOT NULL;
5618:
5619: CURSOR get_line_price(l_line_id NUMBER) IS

Line 5649: SELECT amount FROM oks_level_elements

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
5651: cle_id = l_cle_id;
5652:
5653: l_amount NUMBER;

Line 5738: FROM oks_level_elements

5734: --Check for level element exists
5735:
5736: SELECT COUNT(id)
5737: INTO l_bs_rec
5738: FROM oks_level_elements
5739: WHERE cle_id = top_line_grp_rec.id; -- rul_id = rules_rec.id;
5740:
5741: IF l_bs_rec = 0
5742: THEN

Line 6016: FROM oks_level_elements

6012: l_rules_ctr := 1;
6013: */
6014: SELECT COUNT(id)
6015: INTO l_bs_rec
6016: FROM oks_level_elements
6017: WHERE cle_id = line_grp_rec.id; -- rul_id = rules_rec.id;
6018:
6019: IF l_bs_rec = 0 THEN
6020: -- store SQL error message on message stack