DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_PAYROLL_ACTIONS

Line 71: c_date_earned in pay_payroll_actions.date_earned%TYPE

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

Line 249: p_date_earned in pay_payroll_actions.date_earned%TYPE

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

Line 257: p_date_earned in pay_payroll_actions.date_earned%TYPE,

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

Line 266: p_date_earned in pay_payroll_actions.date_earned%TYPE,

262:
263: function count_retro_periods
264: (
265: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
266: p_date_earned in pay_payroll_actions.date_earned%TYPE,
267: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
268: p_use_tax_flag IN VARCHAR2, --4415795
269: p_mode IN VARCHAR2 DEFAULT 'E' --7665727
270: )return number;

Line 276: p_date_earned in pay_payroll_actions.date_earned%TYPE,

272: /*bug 7665727*/
273: function count_retro_periods_2009
274: (
275: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
276: p_date_earned in pay_payroll_actions.date_earned%TYPE,
277: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
278: p_use_tax_flag IN VARCHAR2, --4415795
279: p_mode IN VARCHAR2 --7665727
280: )return number;

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

280: )return number;
281:
282:
283:
284: function calculate_tax(p_date_earned in pay_payroll_actions.date_earned%TYPE,
285: p_period_amount in number,
286: p_period_frequency in number,
287: p_tax_scale in number,
288: p_a1_variable in number,

Line 340: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

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

Line 365: p_date_earned IN pay_payroll_actions.date_earned%TYPE,

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

Line 394: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE

390:
391: FUNCTION calc_average_earnings
392: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
393: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
394: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
395: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
396: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
397: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
398: ,p_period_start_date IN DATE

Line 397: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE

393: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
394: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
395: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
396: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
397: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
398: ,p_period_start_date IN DATE
399: ,p_emp_hire_date IN DATE
400: ,p_earnings_std_ytd IN NUMBER
401: ,p_earnings_std_ptd IN NUMBER

Line 411: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE

407: FUNCTION calc_lt12_prev_spread_tax
408: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
409: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
410: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
411: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
412: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE
413: ,p_average_earnings IN NUMBER
414: ,p_tax_scale IN VARCHAR2
415: ,p_period_frequency IN NUMBER

Line 412: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE

408: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
409: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
410: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
411: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
412: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE
413: ,p_average_earnings IN NUMBER
414: ,p_tax_scale IN VARCHAR2
415: ,p_period_frequency IN NUMBER
416: ,p_spread_tax OUT NOCOPY NUMBER