DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_STREAM_LEVELS_V

Line 905: FROM oks_stream_levels_v

901: IS
902: CURSOR l_billsch_csr (p_cle_id IN NUMBER)
903: IS
904: SELECT ID
905: FROM oks_stream_levels_v
906: WHERE cle_id = p_cle_id;
907:
908: l_strmlvl_id NUMBER;
909: BEGIN

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);