APPS.HR_ENTRY dependencies on HR_LOOKUPS

Line 2706: from hr_lookups h

2702: end if;
2703: begin
2704: select h.meaning
2705: into v_value_format_out
2706: from hr_lookups h
2707: where h.lookup_type = v_lookup_type
2708: and h.lookup_code = v_value_format_in;
2709: exception
2710: when NO_DATA_FOUND then

Line 5392: v_message_text HR_LOOKUPS.meaning%TYPE;

5388: -- Local Variables
5389: v_checkformat_error boolean := false;
5390: -- --
5391: --v_message_text varchar2(80);
5392: v_message_text HR_LOOKUPS.meaning%TYPE;
5393: -- --
5394: v_uom varchar2(30);
5395: v_hot_default_flag varchar2(30);
5396: v_input_currency_code varchar2(30);

Line 5532: from hr_lookups

5528: begin
5529: --
5530: select meaning
5531: into v_message_text
5532: from hr_lookups
5533: where lookup_type = 'UNITS'
5534: and lookup_code = v_uom;
5535: --
5536: exception

Line 6242: l_creator_meaning HR_LOOKUPS.meaning%TYPE;

6238: p_validation_start_date in date,
6239: p_validation_end_date in date) is
6240: -- --
6241: --l_creator_meaning varchar2(80);
6242: l_creator_meaning HR_LOOKUPS.meaning%TYPE;
6243: -- --
6244: l_error_flag varchar2(30) := 'N';
6245: l_dt_update_mode varchar2(30) := nvl(p_dt_update_mode, 'CORRECTION');
6246: l_dt_delete_mode varchar2(30) := nvl(p_dt_delete_mode, 'ZAP');

Line 6277: from hr_lookups h

6273: end if;
6274: begin
6275: select h.meaning
6276: into l_creator_meaning
6277: from hr_lookups h
6278: where h.lookup_type = 'CREATOR_TYPE'
6279: and h.lookup_code = p_creator_type;
6280: exception
6281: when NO_DATA_FOUND then