DBA Data[Home] [Help]

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 2777: from hr_lookups hl

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