DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_ASSIGNMENT_ACTIONS

Line 136: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type, --2610141

132: function periods_since_hire_date
133: (
134: p_payroll_id in number,
135: p_assignment_id in per_all_assignments_f.assignment_id%type,
136: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type, --2610141
137: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type, /*Bug 4451088 */
138: p_period_num in number,
139: p_period_start in date,
140: p_emp_hire_date in date,

Line 137: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type, /*Bug 4451088 */

133: (
134: p_payroll_id in number,
135: p_assignment_id in per_all_assignments_f.assignment_id%type,
136: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type, --2610141
137: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type, /*Bug 4451088 */
138: p_period_num in number,
139: p_period_start in date,
140: p_emp_hire_date in date,
141: p_use_tax_flag IN VARCHAR2 --2610141

Line 258: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/

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;
262:

Line 265: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

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

Line 267: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/

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;
271:

Line 275: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

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

Line 277: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/

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;
281:

Line 313: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

309: It return value of Hours in case the element_id passed is attached to the Salary Basis
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;

Line 341: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,

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,
345: p_retro_effective_date OUT NOCOPY date,

Line 366: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,

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,
370: p_retro_effective_date OUT NOCOPY date,

Line 376: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

372: p_retro_type OUT NOCOPY varchar2
373: )return number;
374: /* Bug#5934468 */
375: function get_spread_earning
376: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
377: p_date_paid in date,
378: p_pre_tax in number,
379: p_spread_earning in number) return number;
380:

Line 382: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

378: p_pre_tax in number,
379: p_spread_earning in number) return number;
380:
381: function get_retro_spread_earning
382: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
383: p_date_paid in date,
384: p_pre_tax in number,
385: p_spread_earning in number) return number;
386:

Line 392: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE

388: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
389: p_date_earned in date) return varchar2;
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

Line 393: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

389: p_date_earned in date) return varchar2;
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

Line 395: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

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
399: ,p_emp_hire_date IN DATE

Line 408: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE

404: ,p_case OUT NOCOPY VARCHAR2)
405: RETURN NUMBER;
406:
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

Line 409: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

405: RETURN NUMBER;
406:
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

Line 410: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

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