[Home] [Help]
87: and el.element_link_id = ee.element_link_id
88: and ee.assignment_id = p_assignment_id
89: and p.effective_start_date <= ee.effective_end_date
90: and p.effective_end_date >= ee.effective_start_date
91: and fnd_number.canonical_to_number(ee.ENTRY_INFORMATION1) = p.payroll_id
92: and p.effective_start_date <= end_of_year
93: and p.effective_end_date >= start_of_year
94: and ee.effective_start_date <= end_of_year
95: and ee.effective_end_date >= start_of_year
192: and LINK.element_type_id = ELEMENT.element_type_id
193: and p_date BETWEEN ELEMENT.effective_start_date
194: AND ELEMENT.effective_end_date
195: and ELEMENT.element_name = 'FR_OVERTIME'
196: and fnd_number.canonical_to_number(TARGET.ENTRY_INFORMATION1)
197: = SCHEME.payroll_id
198: and p_date BETWEEN SCHEME.effective_start_date
199: AND SCHEME.effective_end_date;
200: --
300:
301: /* Load Band information */
302: i := 0;
303: for b in get_band_values(
304: fnd_number.canonical_to_number(scheme.overtime_band_table)) loop
305: i := i + 1;
306: band(i) := b;
307: end loop;
308: --
574: p_retr_ele_id number,
575: p_range_start_chr varchar2,
576: p_range_end_chr varchar2) is
577: select /*+ordered use_nl(i i2) */ rr.result_value,
578: sum(fnd_number.canonical_to_number(rr2.result_value))
579: from pay_assignment_actions a
580: ,pay_run_results r
581: ,pay_input_values_f i
582: ,pay_run_result_values rr
604: and rr.result_value <= p_range_end_chr
605: and rr.result_value >= p_range_start_chr
606: and r.status in ('P','PA')
607: group by rr.result_value
608: having sum(fnd_number.canonical_to_number(rr2.result_value)) >0
609: order by rr.result_value desc;
610: --
611: l_last_regularisation varchar2(30);
612: l_Proc_Seq_sum number;