DBA Data[Home] [Help]

APPS.OKS_OCINT_PUB dependencies on OKS_STREAM_LEVELS_V

Line 29: FROM oks_stream_levels_v

25: IS
26: CURSOR l_billsch_csr (p_cle_id IN NUMBER)
27: IS
28: SELECT ID
29: FROM oks_stream_levels_v
30: WHERE cle_id = p_cle_id;
31:
32: l_strmlvl_id NUMBER;
33: BEGIN

Line 59: FROM oks_stream_levels_v sll, oks_level_elements lvl

55: IS
56: CURSOR l_billsll_csr (p_cle_id IN NUMBER)
57: IS
58: SELECT 'x'
59: FROM oks_stream_levels_v sll, oks_level_elements lvl
60: WHERE lvl.rul_id = sll.ID AND sll.cle_id = p_cle_id;
61:
62: v_flag BOOLEAN := FALSE;
63: v_temp VARCHAR2 (5);