DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_PAYROLL_ACTIONS

Line 63: c_date_earned in pay_payroll_actions.date_earned%TYPE

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
67: WHERE pee.element_entry_id=c_element_entry_id

Line 222: p_date_earned in pay_payroll_actions.date_earned%TYPE

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:
226:

Line 230: p_date_earned in pay_payroll_actions.date_earned%TYPE,

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
234: )return number;

Line 240: p_date_earned in pay_payroll_actions.date_earned%TYPE,

236:
237: function count_retro_periods
238: (
239: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
240: p_date_earned in pay_payroll_actions.date_earned%TYPE,
241: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
242: p_use_tax_flag IN VARCHAR2 --4415795
243: )return number;
244:

Line 246: function calculate_tax(p_date_earned in pay_payroll_actions.date_earned%TYPE,

242: p_use_tax_flag IN VARCHAR2 --4415795
243: )return number;
244:
245:
246: function calculate_tax(p_date_earned in pay_payroll_actions.date_earned%TYPE,
247: p_period_amount in number,
248: p_period_frequency in number,
249: p_tax_scale in number,
250: p_a1_variable in number,

Line 302: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

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,
306: p_orig_effective_date OUT NOCOPY date,

Line 327: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

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,
331: p_orig_effective_date OUT NOCOPY date,