APPS.PAY_AU_PAYE_FF dependencies on PAY_ELEMENT_ENTRIES_F

Line 62: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

58: * round_to_5c = rounds values to nearest 5c using
59: * ATO rules
60: */
61:
62: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
63: c_date_earned in pay_payroll_actions.date_earned%TYPE
64: ) is
65: SELECT creator_type
66: FROM pay_element_entries_f pee

Line 66: FROM pay_element_entries_f pee

62: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
63: c_date_earned in pay_payroll_actions.date_earned%TYPE
64: ) is
65: SELECT creator_type
66: FROM pay_element_entries_f pee
67: WHERE pee.element_entry_id=c_element_entry_id
68: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
69:
70:

Line 221: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

217: return number;
218:
219: function check_if_retro
220: (
221: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
222: p_date_earned in pay_payroll_actions.date_earned%TYPE
223:
224: )return varchar2;
225:

Line 229: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

225:
226:
227: function get_retro_period
228: (
229: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
230: p_date_earned in pay_payroll_actions.date_earned%TYPE,
231: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
232: p_retro_start_date out NOCOPY date,
233: p_retro_end_date out NOCOPY date

Line 276: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,

272: */
273: FUNCTION get_salary_basis_hours
274: (
275: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
276: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,
277: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
278: )
279: RETURN NUMBER;
280:

Line 301: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,

297: and other related information for an element entry
298: */
299: FUNCTION get_enhanced_retro_period
300: (
301: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
302: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
303: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
304: p_retro_start_date OUT NOCOPY date,
305: p_retro_end_date OUT NOCOPY date,

Line 326: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,

322: */
323:
324: FUNCTION get_retro_time_span
325: (
326: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
327: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
328: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
329: p_retro_start_date OUT NOCOPY date,
330: p_retro_end_date OUT NOCOPY date,