DBA Data[Home] [Help]

APPS.CS_KB_CTX_PKG dependencies on CS_LOOKUPS

Line 1665: FROM cs_lookups

1661:
1662: -- Add access level section
1663: CURSOR access_levels_csr IS --(p_element_id in NUMBER) is
1664: SELECT lookup_code
1665: FROM cs_lookups
1666: WHERE lookup_type = 'CS_KB_ACCESS_LEVEL'
1667: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1668: AND TRUNC(NVL(end_date_active, SYSDATE))
1669: AND TO_NUMBER(lookup_code) <= p_access_level;