eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ENTRY_API dependencies on HR_LOOKUPS

Line 730: from hr_lookups HL

726: p_lookup_type varchar2,
727: p_meaning varchar2
728: ) is
729: select HL.lookup_code
730: from hr_lookups HL
731: where HL.lookup_type = p_lookup_type
732: and HL.meaning = p_meaning;
733: --
734: -- Cursor that checks to make sure that the coverage level for a benefit

Line 1043: FROM HR_LOOKUPS h

1039: IF p_lookup_type IS NOT NULL AND p_default_value IS NOT NULL THEN
1040: BEGIN
1041: SELECT h.meaning
1042: INTO l_default
1043: FROM HR_LOOKUPS h
1044: WHERE h.lookup_type = p_lookup_type
1045: and h.lookup_code = p_default_value
1046: ;
1047: EXCEPTION

Line 1096: from hr_lookups h

1092: p_default_value is not null) then
1093: begin
1094: select h.meaning
1095: into l_default
1096: from hr_lookups h
1097: where h.lookup_type = p_lookup_type
1098: and h.lookup_code = p_default_value;
1099: exception
1100: when NO_DATA_FOUND then

Line 2774: from hr_lookups hl

2770: begin
2771: --
2772: select hl.lookup_code
2773: into v_varchar_variable
2774: from hr_lookups hl
2775: where hl.lookup_type = 'ELE_ENTRY_REASON'
2776: and hl.lookup_code = p_reason
2777: and hl.enabled_flag = 'Y'
2778: and p_effective_date between