APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_STREAM_LEVELS_B

Line 1332: FROM oks_level_elements a, oks_stream_levels_b b

1328: -- if date_completed is not null then it's billed.
1329: CURSOR get_date_complete (l_line_id NUMBER)
1330: IS
1331: SELECT a.date_completed
1332: FROM oks_level_elements a, oks_stream_levels_b b
1333: WHERE b.cle_id = l_line_id AND a.rul_id = b.ID;
1334:
1335: CURSOR target_line (
1336: l_line_id NUMBER,

Line 6853: FROM oks_stream_levels_b strm, oks_level_elements elmnts

6849:
6850: CURSOR l_rule_csr (p_cle_id NUMBER)
6851: IS
6852: SELECT elmnts.ID
6853: FROM oks_stream_levels_b strm, oks_level_elements elmnts
6854: WHERE strm.cle_id = p_cle_id AND elmnts.rul_id = strm.ID;
6855:
6856: CURSOR l_credit_csr (p_cle_id NUMBER)
6857: IS

Line 7717: FROM oks_stream_levels_b strm, oks_level_elements elmnts

7713: --level element id
7714: CURSOR l_rule_csr (p_cle_id NUMBER)
7715: IS
7716: SELECT elmnts.ID
7717: FROM oks_stream_levels_b strm, oks_level_elements elmnts
7718: WHERE strm.cle_id = p_cle_id AND elmnts.rul_id = strm.ID;
7719:
7720: --total billed amount
7721: CURSOR l_billed_amount_csr (p_cle_id NUMBER)