APPS.HR_CALENDAR_NODE_TYPE_API dependencies on HR_LOOKUPS

Line 36: select 'x' from HR_LOOKUPS

32: -- Check if the lookup exists already
33: -- for the current language
34: --
35: CURSOR csr_lookup_unique IS
36: select 'x' from HR_LOOKUPS
37: where lookup_type = 'HIERARCHY_NODE_TYPE'
38: and lookup_code = p_child_node_type;
39:
40: l_proc varchar2(80) := g_package||'create_node_type';

Line 253: FROM hr_lookups

249: -- return the current lookup value for the current lang, etc
250: -- for the child node type
251: CURSOR csr_lookup IS
252: SELECT lookup_code, created_by, meaning, description
253: FROM hr_lookups
254: WHERE lookup_type = 'HIERARCHY_NODE_TYPE'
255: AND lookup_code = (SELECT child_node_type
256: FROM per_gen_hier_node_types
257: WHERE hier_node_type_id = p_hier_node_type_id);