DBA Data[Home] [Help]

APPS.CS_KB_CTX_PKG dependencies on CS_LOOKUPS

Line 1072: FROM cs_lookups

1068:
1069: -- Add access level section
1070: CURSOR access_levels_csr IS --(p_element_id in NUMBER) is
1071: SELECT lookup_code
1072: FROM cs_lookups
1073: WHERE lookup_type = 'CS_KB_ACCESS_LEVEL'
1074: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1075: AND TRUNC(NVL(end_date_active, SYSDATE))
1076: AND TO_NUMBER(lookup_code) <= p_access_level;