APPS.HXC_TER_BUS dependencies on HR_LOOKUPS

Line 417: FROM hr_lookups

413: l_proc varchar2(72);
414: --
415: CURSOR csr_chk_rule_usage IS
416: SELECT 'ok'
417: FROM hr_lookups
418: WHERE lookup_type = 'HXC_APPROVAL_RULE_USAGE'
419: AND lookup_code = p_rule_usage;
420: --
421: l_valid_usage VARCHAR2(5) := NULL;

Line 444: -- check if the rule_usage name exists in HR_LOOKUPS

440: if g_debug then
441: hr_utility.set_location('In:'||l_proc, 10);
442: end if;
443: --
444: -- check if the rule_usage name exists in HR_LOOKUPS
445: --
446: OPEN csr_chk_rule_usage;
447: FETCH csr_chk_rule_usage INTO l_valid_usage;
448: CLOSE csr_chk_rule_usage;