APPS.PAYPLNK dependencies on HR_LOOKUPS

Line 79: from hr_lookups hlk

75: where bah.batch_id = l_batch_id;
76: --
77: cursor csr_status_chk (l_user_status in varchar2) is
78: select 'x'
79: from hr_lookups hlk
80: where hlk.lookup_type = 'BATCH_STATUS'
81: and sysdate between nvl(hlk.start_date_active,sysdate)
82: and nvl(hlk.end_date_active,
83: hr_general.end_of_time)

Line 168: from hr_lookups HL

164: cursor csr_valid_lookup
165: (p_lookup_type varchar2,
166: p_lookup_code varchar2) is
167: select HL.meaning
168: from hr_lookups HL
169: where HL.lookup_type = p_lookup_type
170: and HL.lookup_code = p_lookup_code;
171: --
172: begin

Line 2267: from hr_lookups hlk

2263: into l_exists
2264: from sys.dual
2265: where exists
2266: (select null
2267: from hr_lookups hlk
2268: where upper( hlk.lookup_type) = 'CONTROL_TYPE'
2269: and sysdate between nvl(hlk.start_date_active,sysdate)
2270: and nvl(hlk.end_date_active,
2271: hr_general.end_of_time)

Line 2300: from hr_lookups hlk

2296: else
2297: begin
2298: select 'x'
2299: into l_exists
2300: from hr_lookups hlk
2301: where hlk.lookup_type = 'CONTROL_TYPE'
2302: and sysdate between nvl(hlk.start_date_active,
2303: sysdate)
2304: and nvl(hlk.end_date_active,

Line 2341: from hr_lookups hlk -- control type exists so we can select meaning

2337: -- set bac.control_status = 'E'
2338: -- where current of csr_all_controls;
2339:
2340: select hlk.meaning into l_std_message -- we already checked to see if this
2341: from hr_lookups hlk -- control type exists so we can select meaning
2342: where hlk.lookup_type = 'CONTROL_TYPE'
2343: and hlk.lookup_code = g_control_record.control_type;
2344:
2345: hr_utility.set_message(801,'HR_34854_ERROR_IN_STD_TOTALS');

Line 4871: l_reason hr_lookups.lookup_code%TYPE := null;

4867: --
4868: l_effective_end_date date := null;
4869: l_effective_start_date date := null;
4870: l_element_entry_id number := null;
4871: l_reason hr_lookups.lookup_code%TYPE := null;
4872: l_creator_id number;
4873: c_passed_inp_tbl hr_entry.number_table;
4874: c_passed_val_tbl hr_entry.varchar2_table;
4875: i binary_integer :=0;

Line 4903: from hr_lookups hl

4899: --
4900: IF l_line_record.reason IS NOT NULL THEN
4901: select hl.lookup_code
4902: into l_reason
4903: from hr_lookups hl
4904: where hl.lookup_type = 'ELE_ENTRY_REASON'
4905: and hl.meaning = l_line_record.reason;
4906: END IF;
4907: --

Line 5122: l_reason hr_lookups.lookup_code%TYPE := null;

5118: p_passed_inp_tbl in hr_entry.number_table,
5119: p_passed_val_tbl in hr_entry.varchar2_table
5120: ) is
5121: --
5122: l_reason hr_lookups.lookup_code%TYPE := null;
5123: --
5124: l_stime number(30);
5125: l_etime number(30);
5126: l_time_out boolean := FALSE;

Line 5137: from hr_lookups hl

5133: --
5134: IF l_line_record.reason IS NOT NULL THEN
5135: select hl.lookup_code
5136: into l_reason
5137: from hr_lookups hl
5138: where hl.lookup_type = 'ELE_ENTRY_REASON'
5139: and hl.meaning = l_line_record.reason;
5140: END IF;
5141: --