[Home] [Help]
92: --
93: IF p_sort_order = 'NAME' THEN
94: l_order_by := ' order by per.full_name';
95: ELSIF p_sort_order = 'NUMBER' THEN
96: l_order_by := ' order by fnd_number.canonical_to_number(per.employee_number)';
97: END IF;
98: --
99: hr_utility.set_location('Order by clause is: '||l_order_by, 30);
100: --
391: Cursor csr_dif_acc_periods is
392: select asg.effective_start_date start_date,
393: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_date_from),1,1) asg_catg,
394: asg.payroll_id payroll_id,
395: decode(ctr.ctr_information12, 'HOUR', fnd_number.canonical_to_number(ctr.ctr_information11), asg.normal_hours) wkg_hours
396: from per_all_assignments_f asg,
397: per_contracts_f ctr
398: where asg.person_id= p_emp_id
399: and asg.effective_end_date >= p_date_from
425: and abs.person_id = p_emp_id
426: and abs.abs_information_category = 'FR_TRAINING_ABSENCE'
427: and abs.date_start between p_date_from and p_date_to
428: and pap.accrual_plan_id = p_accrual_plan_id
429: and po.vendor_id = fnd_number.canonical_to_number(abs.abs_information3);
430: --
431: -- Cursor getting adjustment element entries
432: Cursor csr_dif_adj_entries(c_assignment_id number,
433: c_start_date date,
434: c_end_date date) is
435: select ele.element_name adj_element,
436: to_char(pee.effective_start_date, 'dd-Mon-yy') adj_start,
437: to_char(pee.effective_end_date, 'dd-Mon-yy') adj_end,
438: round(fnd_number.canonical_to_number(pev.screen_entry_value)*fnd_number.canonical_to_number(ncr.add_or_subtract), 2) adj_hours,
439: hr_general.decode_lookup('ADD_SUBTRACT',ncr.add_or_subtract) add_or_subtract
440: from pay_accrual_plans pap,
441: pay_net_calculation_rules ncr,
442: pay_element_entries_f pee,