59: END fetch_absence_details;
60: --------------------------------------------------------------------------------
61: function fetch_element_type (p_effective_date in date,
62: p_absence_category varchar2) return number is
63: lv_element_type_id pay_element_types_f.element_type_id%type;
64: lv_element_name pay_element_types_f.element_name%TYPE ;
65:
66: cursor csr_element_details (p_element_name varchar2 ) is
67: select element_type_id
60: --------------------------------------------------------------------------------
61: function fetch_element_type (p_effective_date in date,
62: p_absence_category varchar2) return number is
63: lv_element_type_id pay_element_types_f.element_type_id%type;
64: lv_element_name pay_element_types_f.element_name%TYPE ;
65:
66: cursor csr_element_details (p_element_name varchar2 ) is
67: select element_type_id
68: from pay_element_types_f
64: lv_element_name pay_element_types_f.element_name%TYPE ;
65:
66: cursor csr_element_details (p_element_name varchar2 ) is
67: select element_type_id
68: from pay_element_types_f
69: where element_name = p_element_name
70: and p_effective_date between effective_start_date
71: and effective_end_date;
72: begin