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_JP_ISDF_SS_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 163: l_rate pay_user_column_instances_f.value%type;

159: l_business_group_id number;
160: l_effective_date date;
161: --
162: l_legislation_code varchar2(2);
163: l_rate pay_user_column_instances_f.value%type;
164: l_add_adj pay_user_column_instances_f.value%type;
165: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
166: l_snonlife_calc3 pay_user_column_instances_f.value%type;
167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;

Line 164: l_add_adj pay_user_column_instances_f.value%type;

160: l_effective_date date;
161: --
162: l_legislation_code varchar2(2);
163: l_rate pay_user_column_instances_f.value%type;
164: l_add_adj pay_user_column_instances_f.value%type;
165: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
166: l_snonlife_calc3 pay_user_column_instances_f.value%type;
167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
168: l_dct_cnt number := 0;

Line 165: l_lnonlife_calc3 pay_user_column_instances_f.value%type;

161: --
162: l_legislation_code varchar2(2);
163: l_rate pay_user_column_instances_f.value%type;
164: l_add_adj pay_user_column_instances_f.value%type;
165: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
166: l_snonlife_calc3 pay_user_column_instances_f.value%type;
167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
168: l_dct_cnt number := 0;
169: l_nonlife_max pay_user_column_instances_f.value%type;

Line 166: l_snonlife_calc3 pay_user_column_instances_f.value%type;

162: l_legislation_code varchar2(2);
163: l_rate pay_user_column_instances_f.value%type;
164: l_add_adj pay_user_column_instances_f.value%type;
165: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
166: l_snonlife_calc3 pay_user_column_instances_f.value%type;
167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
168: l_dct_cnt number := 0;
169: l_nonlife_max pay_user_column_instances_f.value%type;
170: l_nonlife_max_2007 pay_user_column_instances_f.value%type;

Line 167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;

163: l_rate pay_user_column_instances_f.value%type;
164: l_add_adj pay_user_column_instances_f.value%type;
165: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
166: l_snonlife_calc3 pay_user_column_instances_f.value%type;
167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
168: l_dct_cnt number := 0;
169: l_nonlife_max pay_user_column_instances_f.value%type;
170: l_nonlife_max_2007 pay_user_column_instances_f.value%type;
171: --

Line 169: l_nonlife_max pay_user_column_instances_f.value%type;

165: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
166: l_snonlife_calc3 pay_user_column_instances_f.value%type;
167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
168: l_dct_cnt number := 0;
169: l_nonlife_max pay_user_column_instances_f.value%type;
170: l_nonlife_max_2007 pay_user_column_instances_f.value%type;
171: --
172: type t_sp_calc_rec is record(
173: range_a pay_user_rows_f.row_low_range_or_name%type,

Line 170: l_nonlife_max_2007 pay_user_column_instances_f.value%type;

166: l_snonlife_calc3 pay_user_column_instances_f.value%type;
167: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
168: l_dct_cnt number := 0;
169: l_nonlife_max pay_user_column_instances_f.value%type;
170: l_nonlife_max_2007 pay_user_column_instances_f.value%type;
171: --
172: type t_sp_calc_rec is record(
173: range_a pay_user_rows_f.row_low_range_or_name%type,
174: range_b pay_user_rows_f.row_low_range_or_name%type,

Line 175: val pay_user_column_instances_f.value%type);

171: --
172: type t_sp_calc_rec is record(
173: range_a pay_user_rows_f.row_low_range_or_name%type,
174: range_b pay_user_rows_f.row_low_range_or_name%type,
175: val pay_user_column_instances_f.value%type);
176: type t_sp_calc_tbl is table of t_sp_calc_rec index by binary_integer;
177: l_sp_calc_tbl t_sp_calc_tbl;
178: --
179: cursor csr_pact

Line 220: pay_user_column_instances_f puci

216: select /* +ORDERED */
217: puc.user_column_name,
218: puci.value
219: from pay_user_columns puc,
220: pay_user_column_instances_f puci
221: where puc.user_table_id = p_user_table_id
222: and puci.user_column_id = puc.user_column_id
223: and puci.user_row_id = p_row_id
224: and p_effective_date