APPS.HR_ENTRY dependencies on HR_LOOKUPS

Line 2455: from hr_lookups h

2451: end if;
2452: begin
2453: select h.meaning
2454: into v_value_format_out
2455: from hr_lookups h
2456: where h.lookup_type = v_lookup_type
2457: and h.lookup_code = v_value_format_in;
2458: exception
2459: when NO_DATA_FOUND then

Line 5016: v_message_text HR_LOOKUPS.meaning%TYPE;

5012: -- Local Variables
5013: v_checkformat_error boolean := false;
5014: -- --
5015: --v_message_text varchar2(80);
5016: v_message_text HR_LOOKUPS.meaning%TYPE;
5017: -- --
5018: v_uom varchar2(30);
5019: v_hot_default_flag varchar2(30);
5020: v_input_currency_code varchar2(30);

Line 5143: from hr_lookups

5139: begin
5140: --
5141: select meaning
5142: into v_message_text
5143: from hr_lookups
5144: where lookup_type = 'UNITS'
5145: and lookup_code = v_uom;
5146: --
5147: exception

Line 5853: l_creator_meaning HR_LOOKUPS.meaning%TYPE;

5849: p_validation_start_date in date,
5850: p_validation_end_date in date) is
5851: -- --
5852: --l_creator_meaning varchar2(80);
5853: l_creator_meaning HR_LOOKUPS.meaning%TYPE;
5854: -- --
5855: l_error_flag varchar2(30) := 'N';
5856: l_dt_update_mode varchar2(30) := nvl(p_dt_update_mode, 'CORRECTION');
5857: l_dt_delete_mode varchar2(30) := nvl(p_dt_delete_mode, 'ZAP');

Line 5888: from hr_lookups h

5884: end if;
5885: begin
5886: select h.meaning
5887: into l_creator_meaning
5888: from hr_lookups h
5889: where h.lookup_type = 'CREATOR_TYPE'
5890: and h.lookup_code = p_creator_type;
5891: exception
5892: when NO_DATA_FOUND then