DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 117: c_assignment_id pay_assignment_actions.assignment_id%type,

113:
114: -- Procedure for Batch Balance Retrieval
115: PROCEDURE get_value_bbr(c_year_start DATE,
116: c_year_end DATE,
117: c_assignment_id pay_assignment_actions.assignment_id%type,
118: c_fbt_rate ff_globals_f.global_value%TYPE,
119: c_ml_rate ff_globals_f.global_value%TYPE,
120: p_assignment_action_id pay_assignment_actions.assignment_id%type,
121: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

Line 120: p_assignment_action_id pay_assignment_actions.assignment_id%type,

116: c_year_end DATE,
117: c_assignment_id pay_assignment_actions.assignment_id%type,
118: c_fbt_rate ff_globals_f.global_value%TYPE,
119: c_ml_rate ff_globals_f.global_value%TYPE,
120: p_assignment_action_id pay_assignment_actions.assignment_id%type,
121: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
122: p_termination_date DATE, --Bug 3098367
123: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367
124: p_output_tab OUT NOCOPY bal_tab

Line 218: p_assignment_id pay_assignment_actions.assignment_id%type,

214:
215: /* bug 7571001 - p_meesage introduced by 4863149 is removed */
216: Function get_total_allowances ( p_year_start DATE,
217: p_year_end DATE,
218: p_assignment_id pay_assignment_actions.assignment_id%type,
219: p_assignment_action_id pay_assignment_actions.assignment_id%type,
220: p_tax_unit_id hr_all_organization_units.organization_id%type)
221: return number;
222:

Line 219: p_assignment_action_id pay_assignment_actions.assignment_id%type,

215: /* bug 7571001 - p_meesage introduced by 4863149 is removed */
216: Function get_total_allowances ( p_year_start DATE,
217: p_year_end DATE,
218: p_assignment_id pay_assignment_actions.assignment_id%type,
219: p_assignment_action_id pay_assignment_actions.assignment_id%type,
220: p_tax_unit_id hr_all_organization_units.organization_id%type)
221: return number;
222:
223:

Line 226: c_assignment_id pay_assignment_actions.assignment_id%type,

222:
223:
224:
225: Function get_total_fbt(c_year_start DATE, --Bug#3213539
226: c_assignment_id pay_assignment_actions.assignment_id%type,
227: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
228: c_fbt_rate ff_globals_f.global_value%TYPE,
229: c_ml_rate ff_globals_f.global_value%TYPE,
230: p_termination VARCHAR2)

Line 251: c_assignment_id pay_assignment_actions.assignment_id%type,

247: function Total_Lump_Sum_D_Payments -- Bug 3263659
248: return number ;
249:
250: function Total_Lump_Sum_E_Payments(c_year_end DATE,
251: c_assignment_id pay_assignment_actions.assignment_id%type,
252: c_registered_employer NUMBER) --2610141
253: return number ;
254:
255: function Total_Union_fees -- Bug 3263659

Line 273: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

269: function Total_Invalidity_Payments -- Bug 3263659
270: return number ;
271:
272: function etp_details
273: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
274: ,p_year_start in pay_payroll_Actions.effective_date%type
275: ,p_year_end in pay_payroll_Actions.effective_date%type)
276: return number;
277:

Line 310: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL

306:
307: PROCEDURE get_group_values_bbr
308: (p_year_start DATE
309: ,p_year_end DATE
310: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
311: , p_date_earned IN date
312: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
313: , p_group_output_tab OUT NOCOPY bal_tab );
314:

Line 312: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

308: (p_year_start DATE
309: ,p_year_end DATE
310: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
311: , p_date_earned IN date
312: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
313: , p_group_output_tab OUT NOCOPY bal_tab );
314:
315: PROCEDURE get_assgt_curr_term_values_bbr
316: ( p_year_start IN DATE

Line 318: , p_assignment_id IN pay_assignment_actions.assignment_id%type

314:
315: PROCEDURE get_assgt_curr_term_values_bbr
316: ( p_year_start IN DATE
317: , p_year_end IN DATE
318: , p_assignment_id IN pay_assignment_actions.assignment_id%type
319: , p_fbt_rate IN ff_globals_f.global_value%TYPE
320: , p_ml_rate IN ff_globals_f.global_value%TYPE
321: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
322: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE

Line 321: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type

317: , p_year_end IN DATE
318: , p_assignment_id IN pay_assignment_actions.assignment_id%type
319: , p_fbt_rate IN ff_globals_f.global_value%TYPE
320: , p_ml_rate IN ff_globals_f.global_value%TYPE
321: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
322: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
323: , p_emp_type IN varchar2
324: , p_term_output_tab OUT NOCOPY bal_tab);
325: --, p_message OUT NOCOPY VARCHAR2); /* bug 7571001 - removed the parameter */

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

372: -- internally calls private procedures to archive balances ,
373: -- employee details, employer details and supplier details .
374: --------------------------------------------------------------------
375: procedure archive_code
376: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
377: p_effective_date in date);
378:
379:
380: procedure spawn_ps_report