APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on HR_LOOKUPS

Line 377: l_reason hr_lookups.lookup_code%Type;

373: l_count number := 1;
374: l_entry_value number;
375: l_element_type_id number;
376: l_input_value_id number;
377: l_reason hr_lookups.lookup_code%Type;
378: l_processing_type pay_element_types_f.processing_type%Type;
379: l_element_link_id pay_element_links_f.element_link_id%Type;
380: l_element_entry_id pay_element_entries_f.element_entry_id%Type;
381: l_passed_inp_tbl hr_entry.number_table;

Line 384: cursor csr_lookup_code(p_meaning hr_lookups.meaning%Type) is

380: l_element_entry_id pay_element_entries_f.element_entry_id%Type;
381: l_passed_inp_tbl hr_entry.number_table;
382: l_passed_val_tbl hr_entry.varchar2_table;
383: -- Cursor to pickup the lookup code
384: cursor csr_lookup_code(p_meaning hr_lookups.meaning%Type) is
385: select hl.lookup_code
386: from hr_lookups hl
387: where hl.lookup_type = 'ELE_ENTRY_REASON'
388: and hl.meaning = p_meaning;

Line 386: from hr_lookups hl

382: l_passed_val_tbl hr_entry.varchar2_table;
383: -- Cursor to pickup the lookup code
384: cursor csr_lookup_code(p_meaning hr_lookups.meaning%Type) is
385: select hl.lookup_code
386: from hr_lookups hl
387: where hl.lookup_type = 'ELE_ENTRY_REASON'
388: and hl.meaning = p_meaning;
389: --
390: begin