194: RETURN BOOLEAN;
195:
196: FUNCTION valid_for_summing (
197: p_element_id IN pay_element_types_f.element_type_id%TYPE,
198: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
199: p_day IN DATE,
200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
201: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
202: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
198: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
199: p_day IN DATE,
200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
201: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
202: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
203: DEFAULT NULL,
204: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
205: DEFAULT NULL,
206: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
201: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
202: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
203: DEFAULT NULL,
204: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
205: DEFAULT NULL,
206: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
207: DEFAULT NULL,
208: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
202: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
203: DEFAULT NULL,
204: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
205: DEFAULT NULL,
206: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
207: DEFAULT NULL,
208: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
209: DEFAULT NULL,
210: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
204: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
205: DEFAULT NULL,
206: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
207: DEFAULT NULL,
208: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
209: DEFAULT NULL,
210: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
211: DEFAULT NULL,
212: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
206: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
207: DEFAULT NULL,
208: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
209: DEFAULT NULL,
210: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
211: DEFAULT NULL,
212: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
213: DEFAULT NULL,
214: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
208: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
209: DEFAULT NULL,
210: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
211: DEFAULT NULL,
212: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
213: DEFAULT NULL,
214: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
215: DEFAULT NULL
216: )
210: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
211: DEFAULT NULL,
212: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
213: DEFAULT NULL,
214: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
215: DEFAULT NULL
216: )
217: RETURN BOOLEAN;
218: