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 168: l_rate pay_user_column_instances_f.value%type;

164: l_business_group_id number;
165: l_effective_date date;
166: --
167: l_legislation_code varchar2(2);
168: l_rate pay_user_column_instances_f.value%type;
169: l_add_adj pay_user_column_instances_f.value%type;
170: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
171: l_snonlife_calc3 pay_user_column_instances_f.value%type;
172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;

Line 169: l_add_adj pay_user_column_instances_f.value%type;

165: l_effective_date date;
166: --
167: l_legislation_code varchar2(2);
168: l_rate pay_user_column_instances_f.value%type;
169: l_add_adj pay_user_column_instances_f.value%type;
170: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
171: l_snonlife_calc3 pay_user_column_instances_f.value%type;
172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
173: l_dct_cnt number := 0;

Line 170: l_lnonlife_calc3 pay_user_column_instances_f.value%type;

166: --
167: l_legislation_code varchar2(2);
168: l_rate pay_user_column_instances_f.value%type;
169: l_add_adj pay_user_column_instances_f.value%type;
170: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
171: l_snonlife_calc3 pay_user_column_instances_f.value%type;
172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
173: l_dct_cnt number := 0;
174: l_nonlife_max pay_user_column_instances_f.value%type;

Line 171: l_snonlife_calc3 pay_user_column_instances_f.value%type;

167: l_legislation_code varchar2(2);
168: l_rate pay_user_column_instances_f.value%type;
169: l_add_adj pay_user_column_instances_f.value%type;
170: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
171: l_snonlife_calc3 pay_user_column_instances_f.value%type;
172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
173: l_dct_cnt number := 0;
174: l_nonlife_max pay_user_column_instances_f.value%type;
175: l_nonlife_max_2007 pay_user_column_instances_f.value%type;

Line 172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;

168: l_rate pay_user_column_instances_f.value%type;
169: l_add_adj pay_user_column_instances_f.value%type;
170: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
171: l_snonlife_calc3 pay_user_column_instances_f.value%type;
172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
173: l_dct_cnt number := 0;
174: l_nonlife_max pay_user_column_instances_f.value%type;
175: l_nonlife_max_2007 pay_user_column_instances_f.value%type;
176: --

Line 174: l_nonlife_max pay_user_column_instances_f.value%type;

170: l_lnonlife_calc3 pay_user_column_instances_f.value%type;
171: l_snonlife_calc3 pay_user_column_instances_f.value%type;
172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
173: l_dct_cnt number := 0;
174: l_nonlife_max pay_user_column_instances_f.value%type;
175: l_nonlife_max_2007 pay_user_column_instances_f.value%type;
176: --
177: type t_sp_calc_rec is record(
178: range_a pay_user_rows_f.row_low_range_or_name%type,

Line 175: l_nonlife_max_2007 pay_user_column_instances_f.value%type;

171: l_snonlife_calc3 pay_user_column_instances_f.value%type;
172: l_sp_calc_other_inc_calc_rate pay_user_column_instances_f.value%type;
173: l_dct_cnt number := 0;
174: l_nonlife_max pay_user_column_instances_f.value%type;
175: l_nonlife_max_2007 pay_user_column_instances_f.value%type;
176: --
177: type t_sp_calc_rec is record(
178: range_a pay_user_rows_f.row_low_range_or_name%type,
179: range_b pay_user_rows_f.row_low_range_or_name%type,

Line 180: val pay_user_column_instances_f.value%type);

176: --
177: type t_sp_calc_rec is record(
178: range_a pay_user_rows_f.row_low_range_or_name%type,
179: range_b pay_user_rows_f.row_low_range_or_name%type,
180: val pay_user_column_instances_f.value%type);
181: type t_sp_calc_tbl is table of t_sp_calc_rec index by binary_integer;
182: l_sp_calc_tbl t_sp_calc_tbl;
183: --
184: cursor csr_pact

Line 225: pay_user_column_instances_f puci

221: select /* +ORDERED */
222: puc.user_column_name,
223: puci.value
224: from pay_user_columns puc,
225: pay_user_column_instances_f puci
226: where puc.user_table_id = p_user_table_id
227: and puci.user_column_id = puc.user_column_id
228: and puci.user_row_id = p_row_id
229: and p_effective_date

Line 1077: l_rate pay_user_column_instances_f.value%type;

1073: p_action_information_id in number)
1074: is
1075: --
1076: l_proc varchar2(80) := c_package||'get_formpg_prompt2012';
1077: l_rate pay_user_column_instances_f.value%type;
1078: l_add_adj pay_user_column_instances_f.value%type;
1079: l_legislation_code varchar2(2);
1080: --
1081: cursor csr_udt_row(

Line 1078: l_add_adj pay_user_column_instances_f.value%type;

1074: is
1075: --
1076: l_proc varchar2(80) := c_package||'get_formpg_prompt2012';
1077: l_rate pay_user_column_instances_f.value%type;
1078: l_add_adj pay_user_column_instances_f.value%type;
1079: l_legislation_code varchar2(2);
1080: --
1081: cursor csr_udt_row(
1082: p_udt_name in varchar2,

Line 1109: pay_user_column_instances_f puci

1105: select /* +ORDERED */
1106: puc.user_column_name,
1107: puci.value
1108: from pay_user_columns puc,
1109: pay_user_column_instances_f puci
1110: where puc.user_table_id = p_user_table_id
1111: and puci.user_column_id = puc.user_column_id
1112: and puci.user_row_id = p_row_id
1113: and p_effective_date