DBA Data[Home] [Help]

APPS.HR_ACCRUAL_PLAN_API dependencies on HR_LOOKUPS

Line 744: from hr_lookups

740: -- Cursor to get translated values for element and input value names
741: --
742: cursor c_get_lookups(p_lookup_code varchar2) is
743: select meaning
744: from hr_lookups
745: where lookup_type = 'NAME_TRANSLATIONS'
746: and lookup_code = p_lookup_code;
747:
748: --

Line 1052: from hr_lookups hl

1048: begin
1049: --
1050: select hl.meaning
1051: into l_post_termination_rule
1052: from hr_lookups hl
1053: where hl.lookup_type='TERMINATION_RULE'
1054: and hl.lookup_code='F'; -- Final Close
1055: --
1056: exception

Line 2176: from hr_lookups

2172: -- Cursor to get translated values for element and input value names
2173: --
2174: cursor c_get_lookups(p_lookup_code varchar2) is
2175: select meaning
2176: from hr_lookups
2177: where lookup_type = 'NAME_TRANSLATIONS'
2178: and lookup_code = p_lookup_code;
2179:
2180: --

Line 2415: from hr_lookups hl

2411: begin
2412: --
2413: select hl.meaning
2414: into l_post_termination_rule
2415: from hr_lookups hl
2416: where hl.lookup_type='TERMINATION_RULE'
2417: and hl.lookup_code='F'; -- Final Close
2418:
2419: hr_utility.trace('l_post_termination_rule: '||l_post_termination_rule);