eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_SET_ELES

Line 2989: -- AND (SELECT count(*) FROM CS_KB_SET_ELES SE WHERE SE.Set_id = S.Set_Id) =

2985: )
2986:
2987: );
2988: -- 02-Dec-2003 Commented as sql not 8.1.7 compliant
2989: -- AND (SELECT count(*) FROM CS_KB_SET_ELES SE WHERE SE.Set_id = S.Set_Id) =
2990: -- (SELECT count(*)
2991: -- FROM CS_KB_SET_ELES SE,
2992: -- CS_KB_ELEMENTS_B E
2993: -- WHERE SE.Set_id = P_SET_ID --S.Set_Id

Line 2991: -- FROM CS_KB_SET_ELES SE,

2987: );
2988: -- 02-Dec-2003 Commented as sql not 8.1.7 compliant
2989: -- AND (SELECT count(*) FROM CS_KB_SET_ELES SE WHERE SE.Set_id = S.Set_Id) =
2990: -- (SELECT count(*)
2991: -- FROM CS_KB_SET_ELES SE,
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

Line 3006: FROM CS_KB_SET_ELES SE

3002: -- );
3003:
3004: CURSOR Get_Total_Soln_Statements IS
3005: SELECT count(*)
3006: FROM CS_KB_SET_ELES SE
3007: WHERE SE.Set_id = P_SET_ID;
3008:
3009: CURSOR Get_Total_Visible_Statements ( v_stmt_vis NUMBER) IS
3010: SELECT count(*)

Line 3011: FROM CS_KB_SET_ELES SE,

3007: WHERE SE.Set_id = P_SET_ID;
3008:
3009: CURSOR Get_Total_Visible_Statements ( v_stmt_vis NUMBER) IS
3010: SELECT count(*)
3011: FROM CS_KB_SET_ELES SE,
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