APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_USER_ROWS_F

Line 178: range_a pay_user_rows_f.row_low_range_or_name%type,

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,
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;

Line 179: range_b pay_user_rows_f.row_low_range_or_name%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,
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: --

Line 208: pay_user_rows_f pur

204: pur.display_sequence,
205: pur.row_low_range_or_name,
206: pur.row_high_range
207: from pay_user_tables put,
208: pay_user_rows_f pur
209: where put.user_table_name = p_udt_name
210: and nvl(put.legislation_code,'X') = nvl(l_legislation_code,nvl(put.legislation_code,'X'))
211: and pur.user_table_id = put.user_table_id
212: and p_effective_date

Line 1092: pay_user_rows_f pur

1088: pur.display_sequence,
1089: pur.row_low_range_or_name,
1090: pur.row_high_range
1091: from pay_user_tables put,
1092: pay_user_rows_f pur
1093: where put.user_table_name = p_udt_name
1094: and nvl(put.legislation_code,'X') = nvl(l_legislation_code,nvl(put.legislation_code,'X'))
1095: and pur.user_table_id = put.user_table_id
1096: and p_effective_date