APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_STREAM_LEVELS_B

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)