[Home] [Help]
114: l_Tax_Reduction varchar2(5000);
115: l_Labour_Tax_Reduction varchar2(5000);
116: l_Special_Indicators pay_run_result_values.result_value%TYPE;
117: l_Senior_Tax_Reduction varchar2(5000);
118: l_locked_assignment_action_id pay_action_interlocks.locked_action_id%TYPE;
119: l_context_id NUMBER;
120:
121: CURSOR cur_spl_rate(lp_assignment_action_id NUMBER,
122: lp_element_name VARCHAR2,lp_input_value_name VARCHAR2) IS
140: and ppa.date_earned between pet.effective_start_date and pet.effective_end_date
141: and ppa.date_earned between piv.effective_start_date and piv.effective_end_date;
142:
143: cursor getLockedActionid is
144: select max(locked_action_id) from pay_action_interlocks where locking_action_id = p_assignment_action_id;
145:
146: cursor get_context_id is
147: select context_id from ff_contexts where context_name = 'SOURCE_TEXT';
148:
393: l_sn_needed_chr varchar2(10);
394: l_st2_needed_chr varchar2(10);
395: l_found boolean;
396: balCount number;
397: locked_assignment_action_id pay_action_interlocks.locked_action_id%TYPE;
398: --
399: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
400: l_context_lst pay_balance_pkg.t_context_tab;
401: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
513: and pa.effective_date >= l_earliest_ctx_date;
514: l_si_type_name pay_run_result_values.result_value%TYPE;
515: --
516: cursor getLockedActionid is
517: select max(locked_action_id) from pay_action_interlocks where locking_action_id = p_assignment_action_id;
518: --
519: begin
520: --
521: if g_debug then