eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_SOE dependencies on PAY_RUN_RESULT_VALUES

Line 110: l_sp_percentage_rate pay_run_result_values.result_value%TYPE;

106: l_ABW_Allowance NUMBER;
107: l_ABW_Allowance_Stoppage NUMBER;
108: l_WAO_Allowance NUMBER;
109: l_ZVW_Contribution NUMBER;
110: l_sp_percentage_rate pay_run_result_values.result_value%TYPE;
111: l_prev_tax_income pay_run_result_values.result_value%TYPE;
112: l_Tax_Code pay_run_result_values.result_value%TYPE;
113: l_Tax_Table varchar2(5000);
114: l_Tax_Reduction varchar2(5000);

Line 111: l_prev_tax_income pay_run_result_values.result_value%TYPE;

107: l_ABW_Allowance_Stoppage NUMBER;
108: l_WAO_Allowance NUMBER;
109: l_ZVW_Contribution NUMBER;
110: l_sp_percentage_rate pay_run_result_values.result_value%TYPE;
111: l_prev_tax_income pay_run_result_values.result_value%TYPE;
112: l_Tax_Code pay_run_result_values.result_value%TYPE;
113: l_Tax_Table varchar2(5000);
114: l_Tax_Reduction varchar2(5000);
115: l_Labour_Tax_Reduction varchar2(5000);

Line 112: l_Tax_Code pay_run_result_values.result_value%TYPE;

108: l_WAO_Allowance NUMBER;
109: l_ZVW_Contribution NUMBER;
110: l_sp_percentage_rate pay_run_result_values.result_value%TYPE;
111: l_prev_tax_income pay_run_result_values.result_value%TYPE;
112: l_Tax_Code pay_run_result_values.result_value%TYPE;
113: l_Tax_Table varchar2(5000);
114: l_Tax_Reduction varchar2(5000);
115: l_Labour_Tax_Reduction varchar2(5000);
116: l_Special_Indicators pay_run_result_values.result_value%TYPE;

Line 116: l_Special_Indicators pay_run_result_values.result_value%TYPE;

112: l_Tax_Code pay_run_result_values.result_value%TYPE;
113: l_Tax_Table varchar2(5000);
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:

Line 124: from pay_run_result_values prrv,

120:
121: CURSOR cur_spl_rate(lp_assignment_action_id NUMBER,
122: lp_element_name VARCHAR2,lp_input_value_name VARCHAR2) IS
123: select prrv.result_value
124: from pay_run_result_values prrv,
125: pay_run_results prr,
126: pay_element_types_f pet,
127: pay_input_values_f piv,
128: pay_assignment_actions paa,

Line 304: , pay_run_result_values rrv

300: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
301: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
302: from pay_assignment_actions aa
303: , pay_run_results rr
304: , pay_run_result_values rrv
305: , pay_input_values_f iv
306: , pay_input_values_f_tl ivtl
307: , pay_element_types_f et
308: , pay_element_types_f_tl ettl

Line 514: l_si_type_name pay_run_result_values.result_value%TYPE;

510: and aa.assignment_action_id = rr.assignment_action_id
511: and l_action_sequence >= aa.action_sequence
512: and aa.payroll_action_id = pa.payroll_action_id
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: --