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 2168: from hr_lookups

2164: -- Cursor to get translated values for element and input value names
2165: --
2166: cursor c_get_lookups(p_lookup_code varchar2) is
2167: select meaning
2168: from hr_lookups
2169: where lookup_type = 'NAME_TRANSLATIONS'
2170: and lookup_code = p_lookup_code;
2171:
2172: --

Line 2407: from hr_lookups hl

2403: begin
2404: --
2405: select hl.meaning
2406: into l_post_termination_rule
2407: from hr_lookups hl
2408: where hl.lookup_type='TERMINATION_RULE'
2409: and hl.lookup_code='F'; -- Final Close
2410:
2411: hr_utility.trace('l_post_termination_rule: '||l_post_termination_rule);