APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_LEVEL_ELEMENTS

Line 935: FROM oks_stream_levels_v sll, oks_level_elements lvl

931: IS
932: CURSOR l_billsll_csr (p_cle_id IN NUMBER)
933: IS
934: SELECT 'x'
935: FROM oks_stream_levels_v sll, oks_level_elements lvl
936: WHERE lvl.rul_id = sll.ID AND sll.cle_id = p_cle_id;
937:
938: v_flag BOOLEAN := FALSE;
939: v_temp VARCHAR2 (5);

Line 1292: FROM oks_level_elements a, oks_stream_levels_b b

1288: -- if date_completed is not null then it's billed.
1289: CURSOR get_date_complete (l_line_id NUMBER)
1290: IS
1291: SELECT a.date_completed
1292: FROM oks_level_elements a, oks_stream_levels_b b
1293: WHERE b.cle_id = l_line_id AND a.rul_id = b.ID;
1294:
1295: CURSOR target_line (
1296: l_line_id NUMBER,

Line 6685: FROM oks_stream_levels_b strm, oks_level_elements elmnts

6681:
6682: CURSOR l_rule_csr (p_cle_id NUMBER)
6683: IS
6684: SELECT elmnts.ID
6685: FROM oks_stream_levels_b strm, oks_level_elements elmnts
6686: WHERE strm.cle_id = p_cle_id AND elmnts.rul_id = strm.ID;
6687:
6688: CURSOR l_credit_csr (p_cle_id NUMBER)
6689: IS

Line 7536: FROM oks_stream_levels_b strm, oks_level_elements elmnts

7532: --level element id
7533: CURSOR l_rule_csr (p_cle_id NUMBER)
7534: IS
7535: SELECT elmnts.ID
7536: FROM oks_stream_levels_b strm, oks_level_elements elmnts
7537: WHERE strm.cle_id = p_cle_id AND elmnts.rul_id = strm.ID;
7538:
7539: --total billed amount
7540: CURSOR l_billed_amount_csr (p_cle_id NUMBER)