APPS.SSPWSENT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 63: lv_element_type_id pay_element_types_f.element_type_id%type;

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

Line 64: lv_element_name pay_element_types_f.element_name%TYPE ;

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

Line 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