[Home] [Help]
29: CURSOR c_user_rows(vp_business_group_id number,
30: vp_user_table_name varchar2,
31: vp_effective_date date) IS
32: SELECT pur.row_low_range_or_name
33: FROM pay_user_rows_f pur,
34: pay_user_tables put
35: WHERE put.user_table_id=pur.user_table_id
36: and put.business_group_id = vp_business_group_id
37: and put.user_table_name =vp_user_table_name
45: where absence_attendance_id = p_absence_attendance_id;
46:
47:
48:
49: l_row_number pay_user_rows_f.row_low_range_or_name%TYPE;
50: l_proc varchar2(72) := g_package || '.create_Default_Absence_Actions';
51: l_date_start date;
52: l_setup_exists varchar2(30);
53: l_actions_exists varchar2(30);