DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 84: c_assignment_id pay_assignment_actions.assignment_id%type,

80:
81: -- Procedure for Batch Balance Retrieval
82: PROCEDURE get_value_bbr(c_year_start DATE,
83: c_year_end DATE,
84: c_assignment_id pay_assignment_actions.assignment_id%type,
85: c_fbt_rate ff_globals_f.global_value%TYPE,
86: c_ml_rate ff_globals_f.global_value%TYPE,
87: p_assignment_action_id pay_assignment_actions.assignment_id%type,
88: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

Line 87: p_assignment_action_id pay_assignment_actions.assignment_id%type,

83: c_year_end DATE,
84: c_assignment_id pay_assignment_actions.assignment_id%type,
85: c_fbt_rate ff_globals_f.global_value%TYPE,
86: c_ml_rate ff_globals_f.global_value%TYPE,
87: p_assignment_action_id pay_assignment_actions.assignment_id%type,
88: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
89: p_termination_date DATE, --Bug 3098367
90: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367
91: p_output_tab OUT NOCOPY bal_tab,

Line 146: c_assignment_id pay_assignment_actions.assignment_id%type,

142:
143:
144: Function get_total_allowances(c_year_start DATE,
145: c_year_end DATE,
146: c_assignment_id pay_assignment_actions.assignment_id%type,
147: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
148: c_registered_employer NUMBER,
149: c_message OUT NOCOPY VARCHAR2) /* Bug#4863149 */
150: return number;

Line 147: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

143:
144: Function get_total_allowances(c_year_start DATE,
145: c_year_end DATE,
146: c_assignment_id pay_assignment_actions.assignment_id%type,
147: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
148: c_registered_employer NUMBER,
149: c_message OUT NOCOPY VARCHAR2) /* Bug#4863149 */
150: return number;
151:

Line 155: c_assignment_id pay_assignment_actions.assignment_id%type,

151:
152:
153:
154: Function get_total_fbt(c_year_start DATE, --Bug#3213539
155: c_assignment_id pay_assignment_actions.assignment_id%type,
156: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
157: c_fbt_rate ff_globals_f.global_value%TYPE,
158: c_ml_rate ff_globals_f.global_value%TYPE,
159: p_termination VARCHAR2)

Line 180: c_assignment_id pay_assignment_actions.assignment_id%type,

176: function Total_Lump_Sum_D_Payments -- Bug 3263659
177: return number ;
178:
179: function Total_Lump_Sum_E_Payments(c_year_end DATE,
180: c_assignment_id pay_assignment_actions.assignment_id%type,
181: c_registered_employer NUMBER) --2610141
182: return number ;
183:
184: function Total_Union_fees -- Bug 3263659

Line 200: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

196: function Total_Invalidity_Payments -- Bug 3263659
197: return number ;
198:
199: function etp_details
200: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
201: ,p_year_start in pay_payroll_Actions.effective_date%type
202: ,p_year_end in pay_payroll_Actions.effective_date%type)
203: return number;
204:

Line 234: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL

230:
231: PROCEDURE populate_group_def_bal_ids (p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE);
232:
233: PROCEDURE get_group_values_bbr
234: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
235: , p_date_earned IN date
236: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
237: , p_group_output_tab OUT NOCOPY bal_tab );
238:

Line 236: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

232:
233: PROCEDURE get_group_values_bbr
234: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
235: , p_date_earned IN date
236: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
237: , p_group_output_tab OUT NOCOPY bal_tab );
238:
239: PROCEDURE get_assgt_curr_term_values_bbr
240: ( p_year_start IN DATE

Line 242: , p_assignment_id IN pay_assignment_actions.assignment_id%type

238:
239: PROCEDURE get_assgt_curr_term_values_bbr
240: ( p_year_start IN DATE
241: , p_year_end IN DATE
242: , p_assignment_id IN pay_assignment_actions.assignment_id%type
243: , p_fbt_rate IN ff_globals_f.global_value%TYPE
244: , p_ml_rate IN ff_globals_f.global_value%TYPE
245: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
246: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE

Line 245: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type

241: , p_year_end IN DATE
242: , p_assignment_id IN pay_assignment_actions.assignment_id%type
243: , p_fbt_rate IN ff_globals_f.global_value%TYPE
244: , p_ml_rate IN ff_globals_f.global_value%TYPE
245: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
246: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
247: , p_emp_type IN varchar2
248: , p_term_output_tab OUT NOCOPY bal_tab
249: , p_message OUT NOCOPY VARCHAR2); /* Bug#4863149 */

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

296: -- internally calls private procedures to archive balances ,
297: -- employee details, employer details and supplier details .
298: --------------------------------------------------------------------
299: procedure archive_code
300: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
301: p_effective_date in date);
302:
303:
304: procedure spawn_ps_report