66: */
67:
68: g_lumpsum_d number; -- bug 9775171
69:
70: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
71: c_date_earned in pay_payroll_actions.date_earned%TYPE
72: ) is
73: SELECT creator_type
74: FROM pay_element_entries_f pee
70: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
71: c_date_earned in pay_payroll_actions.date_earned%TYPE
72: ) is
73: SELECT creator_type
74: FROM pay_element_entries_f pee
75: WHERE pee.element_entry_id=c_element_entry_id
76: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
77:
78:
244: return number;
245:
246: function check_if_retro
247: (
248: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
249: p_date_earned in pay_payroll_actions.date_earned%TYPE
250:
251: )return varchar2;
252:
252:
253:
254: function get_retro_period
255: (
256: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
257: p_date_earned in pay_payroll_actions.date_earned%TYPE,
258: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
259: p_retro_start_date out NOCOPY date,
260: p_retro_end_date out NOCOPY date
310: */
311: FUNCTION get_salary_basis_hours
312: (
313: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
314: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,
315: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
316: )
317: RETURN NUMBER;
318:
335: and other related information for an element entry
336: */
337: FUNCTION get_enhanced_retro_period
338: (
339: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
340: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
341: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
342: p_retro_start_date OUT NOCOPY date,
343: p_retro_end_date OUT NOCOPY date,
360: */
361:
362: FUNCTION get_retro_time_span
363: (
364: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
365: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
366: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
367: p_retro_start_date OUT NOCOPY date,
368: p_retro_end_date OUT NOCOPY date,