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,
122: p_termination_date DATE, --Bug 3098367
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,
122: p_termination_date DATE, --Bug 3098367
123: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367
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)
231: return number ;
232:
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)
231: return number ;
232:
233:
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
323: , p_emp_type IN varchar2
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
323: , p_emp_type IN varchar2
324: , p_term_output_tab OUT NOCOPY bal_tab);