531: ,p_absence_attendance_type_id NUMBER) is
532: --
533: cursor c1 is
534: select ''
535: from pay_element_types_f
536: where element_type_id = p_element_type_id
537: and p_date_effective between
538: effective_start_date and effective_end_date;
539: elt_rec c1%rowtype;
609: ABT_REC c1%rowtype;
610: --
611: cursor c2 is
612: select max(effective_end_date)
613: from pay_element_types_f
614: where element_type_id = p_element_type_id;
615: --
616: l_temp_iv NUMBER(22);
617: --