DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_STREAM_LEVELS_V

Line 945: FROM oks_stream_levels_v

941: IS
942: CURSOR l_billsch_csr (p_cle_id IN NUMBER)
943: IS
944: SELECT ID
945: FROM oks_stream_levels_v
946: WHERE cle_id = p_cle_id;
947:
948: l_strmlvl_id NUMBER;
949: BEGIN

Line 975: FROM oks_stream_levels_v sll, oks_level_elements lvl

971: IS
972: CURSOR l_billsll_csr (p_cle_id IN NUMBER)
973: IS
974: SELECT 'x'
975: FROM oks_stream_levels_v sll, oks_level_elements lvl
976: WHERE lvl.rul_id = sll.ID AND sll.cle_id = p_cle_id;
977:
978: v_flag BOOLEAN := FALSE;
979: v_temp VARCHAR2 (5);