APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_LEVEL_ELEMENTS

Line 2922: FROM oks_level_elements

2918: -- select date transaction
2919:
2920: CURSOR trx_date_csr(l_cle_id IN NUMBER) IS
2921: SELECT MAX(date_transaction)
2922: FROM oks_level_elements
2923: WHERE parent_cle_id = l_cle_id;
2924:
2925:
2926: -- GCHADHA --

Line 5445: FROM oks_level_elements

5441:
5442: CURSOR level_elements_csr (p_id NUMBER) IS
5443: SELECT date_start, date_transaction, date_to_interface,
5444: amount, date_completed
5445: FROM oks_level_elements
5446: WHERE rul_id = p_id -- is the id in oks_level_elements
5447: AND date_completed IS NULL
5448: ORDER BY date_start; -- Added for bug# 2517147
5449:

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

5442: CURSOR level_elements_csr (p_id NUMBER) IS
5443: SELECT date_start, date_transaction, date_to_interface,
5444: amount, date_completed
5445: FROM oks_level_elements
5446: WHERE rul_id = p_id -- is the id in oks_level_elements
5447: AND date_completed IS NULL
5448: ORDER BY date_start; -- Added for bug# 2517147
5449:
5450: --Level element information - to check amount and periods

Line 5454: FROM oks_level_elements

5450: --Level element information - to check amount and periods
5451:
5452: CURSOR level_elements_amt_csr (p_id NUMBER) IS
5453: SELECT COUNT(rul_id) lvl_count, SUM(amount) lvl_amt
5454: FROM oks_level_elements
5455: WHERE rul_id = p_id -- is the id in oks_level_elements
5456: GROUP BY rul_id;
5457:
5458: --get rle information E/T/P of top line

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

5451:
5452: CURSOR level_elements_amt_csr (p_id NUMBER) IS
5453: SELECT COUNT(rul_id) lvl_count, SUM(amount) lvl_amt
5454: FROM oks_level_elements
5455: WHERE rul_id = p_id -- is the id in oks_level_elements
5456: GROUP BY rul_id;
5457:
5458: --get rle information E/T/P of top line
5459: -- SLH rule

Line 5468: FROM oks_level_elements

5464: AND cle_id = p_cle_id;
5465:
5466: CURSOR level_elements_billed_csr (p_id NUMBER) IS
5467: SELECT SUM(amount) billed_amt
5468: FROM oks_level_elements
5469: WHERE rul_id = p_id
5470: AND date_completed IS NOT NULL;
5471:
5472: CURSOR get_line_price(l_line_id NUMBER) IS

Line 5502: SELECT amount FROM oks_level_elements

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
5504: cle_id = l_cle_id;
5505:
5506: l_amount NUMBER;

Line 5591: FROM oks_level_elements

5587: --Check for level element exists
5588:
5589: SELECT COUNT(id)
5590: INTO l_bs_rec
5591: FROM oks_level_elements
5592: WHERE cle_id = top_line_grp_rec.id; -- rul_id = rules_rec.id;
5593:
5594: IF l_bs_rec = 0
5595: THEN

Line 5869: FROM oks_level_elements

5865: l_rules_ctr := 1;
5866: */
5867: SELECT COUNT(id)
5868: INTO l_bs_rec
5869: FROM oks_level_elements
5870: WHERE cle_id = line_grp_rec.id; -- rul_id = rules_rec.id;
5871:
5872: IF l_bs_rec = 0 THEN
5873: -- store SQL error message on message stack