APPS.PAYPLNK dependencies on HR_LOOKUPS

Line 74: from hr_lookups hlk

70: where bah.batch_id = l_batch_id;
71: --
72: cursor csr_status_chk (l_user_status in varchar2) is
73: select 'x'
74: from hr_lookups hlk
75: where hlk.lookup_type = 'BATCH_STATUS'
76: and sysdate between nvl(hlk.start_date_active,sysdate)
77: and nvl(hlk.end_date_active,
78: hr_general.end_of_time)

Line 164: from hr_lookups HL

160: cursor csr_valid_lookup
161: (p_lookup_type varchar2,
162: p_lookup_code varchar2) is
163: select HL.meaning
164: from hr_lookups HL
165: where HL.lookup_type = p_lookup_type
166: and HL.lookup_code = p_lookup_code;
167: --
168: begin

Line 2269: from hr_lookups hlk

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

Line 2302: from hr_lookups hlk

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

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

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

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

4899: --
4900: l_effective_end_date date := null;
4901: l_effective_start_date date := null;
4902: l_element_entry_id number := null;
4903: l_reason hr_lookups.lookup_code%TYPE := null;
4904: l_creator_id number;
4905: c_passed_inp_tbl hr_entry.number_table;
4906: c_passed_val_tbl hr_entry.varchar2_table;
4907: i binary_integer :=0;

Line 4935: from hr_lookups hl

4931: --
4932: IF l_line_record.reason IS NOT NULL THEN
4933: select hl.lookup_code
4934: into l_reason
4935: from hr_lookups hl
4936: where hl.lookup_type = 'ELE_ENTRY_REASON'
4937: and hl.meaning = l_line_record.reason;
4938: END IF;
4939: --

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

5150: p_passed_inp_tbl in hr_entry.number_table,
5151: p_passed_val_tbl in hr_entry.varchar2_table
5152: ) is
5153: --
5154: l_reason hr_lookups.lookup_code%TYPE := null;
5155: --
5156: l_stime number(30);
5157: l_etime number(30);
5158: l_time_out boolean := FALSE;

Line 5169: from hr_lookups hl

5165: --
5166: IF l_line_record.reason IS NOT NULL THEN
5167: select hl.lookup_code
5168: into l_reason
5169: from hr_lookups hl
5170: where hl.lookup_type = 'ELE_ENTRY_REASON'
5171: and hl.meaning = l_line_record.reason;
5172: END IF;
5173: --