DBA Data[Home] [Help]

APPS.PY_FR_ADDITIONAL_ELEMENT_RULES dependencies on HR_LOOKUPS

Line 146: from hr_lookups

142: and rownum = 1;
143:
144: cursor csr_name_translation(p_code varchar2) is
145: select meaning
146: from hr_lookups
147: where lookup_type = 'NAME_TRANSLATIONS'
148: and lookup_code = p_code;
149:
150: cursor accrual_class_id is

Line 235: from hr_lookups hl

231:
232: hr_utility.set_location('Step '||g_package,815);
233: select hl.meaning
234: into l_act_term_date
235: from hr_lookups hl
236: where hl.lookup_type='TERMINATION_RULE'
237: and hl.lookup_code='A';
238:
239: hr_utility.set_location('Step '||g_package,816);

Line 527: from hr_lookups hl

523: begin
524: --
525: select hl.meaning
526: into l_post_term_rule
527: from hr_lookups hl
528: where hl.lookup_type='TERMINATION_RULE'
529: and hl.lookup_code='F'; -- Final Close
530:
531: select name,legislation_code