APPS.CS_KB_SECURITY_PVT dependencies on CS_LOOKUPS

Line 2780: FROM cs_lookups

2776: RETURN NUMBER IS
2777:
2778: CURSOR GET_STMT_VISIBILITY IS
2779: SELECT lookup_code
2780: FROM cs_lookups
2781: WHERE lookup_type = 'CS_KB_ACCESS_LEVEL'
2782: AND lookup_code = fnd_profile.value('CS_KB_ASSIGNED_STATEMENT_VISIBILITY_LEVEL')
2783: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
2784: AND nvl(End_Date_Active, sysdate+1);

Line 2996: -- FROM cs_lookups

2992: -- CS_KB_ELEMENTS_B E
2993: -- WHERE SE.Set_id = P_SET_ID --S.Set_Id
2994: -- AND SE.Element_id = E.Element_Id
2995: -- AND E.Access_Level >= (SELECT lookup_code
2996: -- FROM cs_lookups
2997: -- WHERE lookup_type = 'CS_KB_ACCESS_LEVEL'
2998: -- AND lookup_code = v_stmt_vis
2999: -- AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3000: -- AND nvl(End_Date_Active, sysdate+1)

Line 3016: FROM cs_lookups

3012: CS_KB_ELEMENTS_B E
3013: WHERE SE.Set_id = P_SET_ID --S.Set_Id
3014: AND SE.Element_id = E.Element_Id
3015: AND E.Access_Level >= (SELECT lookup_code
3016: FROM cs_lookups
3017: WHERE lookup_type = 'CS_KB_ACCESS_LEVEL'
3018: AND lookup_code = v_stmt_vis
3019: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3020: AND nvl(End_Date_Active, sysdate+1)