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_FR_SICKNESS_CALC dependencies on PAY_INPUT_VALUES_F

Line 131: g_gi_info_absence_id_iv_id pay_input_values_f.input_value_id%type;

127: g_ijss_refsal_defbal_id number;
128: g_map_refsal_defbal_id number;
129:
130: g_gi_info_element_type_id pay_element_types_f.element_type_id%type;
131: g_gi_info_absence_id_iv_id pay_input_values_f.input_value_id%type;
132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;

Line 132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;

128: g_map_refsal_defbal_id number;
129:
130: g_gi_info_element_type_id pay_element_types_f.element_type_id%type;
131: g_gi_info_absence_id_iv_id pay_input_values_f.input_value_id%type;
132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;

Line 133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;

129:
130: g_gi_info_element_type_id pay_element_types_f.element_type_id%type;
131: g_gi_info_absence_id_iv_id pay_input_values_f.input_value_id%type;
132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;

Line 134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;

130: g_gi_info_element_type_id pay_element_types_f.element_type_id%type;
131: g_gi_info_absence_id_iv_id pay_input_values_f.input_value_id%type;
132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;

Line 135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;

131: g_gi_info_absence_id_iv_id pay_input_values_f.input_value_id%type;
132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;

Line 136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;

132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;

Line 137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;

133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;

Line 138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;

134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;

Line 139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;

135: g_gi_info_net_iv_id pay_input_values_f.input_value_id%type;
136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;
143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;

Line 140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;

136: g_gi_info_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;
143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;
144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;

Line 141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;

137: g_gi_info_adjustment_iv_id pay_input_values_f.input_value_id%type;
138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;
143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;
144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;
145:

Line 142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;

138: g_gi_info_best_method_iv_id pay_input_values_f.input_value_id%type;
139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;
143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;
144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;
145:
146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;

Line 143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;

139: g_gi_info_start_date_iv_id pay_input_values_f.input_value_id%type;
140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;
143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;
144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;
145:
146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;
147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;

Line 144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;

140: g_gi_info_end_date_iv_id pay_input_values_f.input_value_id%type;
141: g_gi_info_band1_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;
143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;
144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;
145:
146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;
147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;
148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;

Line 147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;

143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;
144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;
145:
146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;
147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;
148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;

Line 148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;

144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;
145:
146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;
147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;
148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;

Line 149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;

145:
146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;
147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;
148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;

Line 150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;

146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;
147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;
148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;

Line 151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;

147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;
148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;

Line 152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;

148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;

Line 153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;

149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;

Line 154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;

150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;

Line 155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;

151: g_gi_i_r_net_iv_id pay_input_values_f.input_value_id%type;
152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;
159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;

Line 156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;

152: g_gi_i_r_ijss_gross_iv_id pay_input_values_f.input_value_id%type;
153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;
159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;
160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;

Line 157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;

153: g_gi_i_r_adjustment_iv_id pay_input_values_f.input_value_id%type;
154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;
159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;
160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;
161:

Line 158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;

154: g_gi_i_r_best_method_iv_id pay_input_values_f.input_value_id%type;
155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;
159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;
160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;
161:
162: g_ben_element_type_id pay_element_types_f.element_type_id%type;

Line 159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;

155: g_gi_i_r_start_date_iv_id pay_input_values_f.input_value_id%type;
156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;
159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;
160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;
161:
162: g_ben_element_type_id pay_element_types_f.element_type_id%type;
163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;

Line 160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;

156: g_gi_i_r_end_date_iv_id pay_input_values_f.input_value_id%type;
157: g_gi_i_r_band1_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;
159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;
160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;
161:
162: g_ben_element_type_id pay_element_types_f.element_type_id%type;
163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;
164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;

Line 163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;

159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;
160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;
161:
162: g_ben_element_type_id pay_element_types_f.element_type_id%type;
163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;
164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;

Line 164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;

160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;
161:
162: g_ben_element_type_id pay_element_types_f.element_type_id%type;
163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;
164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;

Line 165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;

161:
162: g_ben_element_type_id pay_element_types_f.element_type_id%type;
163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;
164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;

Line 166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;

162: g_ben_element_type_id pay_element_types_f.element_type_id%type;
163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;
164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;

Line 167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;

163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;
164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;

Line 168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;

164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;

Line 169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;

165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;

Line 170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;

166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;
174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;

Line 171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;

167: g_ben_duration_iv_id pay_input_values_f.input_value_id%type;
168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;
174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;
175: g_ben_band4_rate_iv_id pay_input_values_f.input_value_id%type;

Line 172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;

168: g_ben_band1_iv_id pay_input_values_f.input_value_id%type;
169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;
174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;
175: g_ben_band4_rate_iv_id pay_input_values_f.input_value_id%type;
176: g_ben_balance_iv_id pay_input_values_f.input_value_id%type;

Line 173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;

169: g_ben_band1_rate_iv_id pay_input_values_f.input_value_id%type;
170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;
174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;
175: g_ben_band4_rate_iv_id pay_input_values_f.input_value_id%type;
176: g_ben_balance_iv_id pay_input_values_f.input_value_id%type;
177:

Line 174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;

170: g_ben_band2_iv_id pay_input_values_f.input_value_id%type;
171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;
174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;
175: g_ben_band4_rate_iv_id pay_input_values_f.input_value_id%type;
176: g_ben_balance_iv_id pay_input_values_f.input_value_id%type;
177:
178: -- Used for LEGI and CAGR

Line 175: g_ben_band4_rate_iv_id pay_input_values_f.input_value_id%type;

171: g_ben_band2_rate_iv_id pay_input_values_f.input_value_id%type;
172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;
174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;
175: g_ben_band4_rate_iv_id pay_input_values_f.input_value_id%type;
176: g_ben_balance_iv_id pay_input_values_f.input_value_id%type;
177:
178: -- Used for LEGI and CAGR
179: TYPE bands_rec IS RECORD

Line 176: g_ben_balance_iv_id pay_input_values_f.input_value_id%type;

172: g_ben_band3_iv_id pay_input_values_f.input_value_id%type;
173: g_ben_band3_rate_iv_id pay_input_values_f.input_value_id%type;
174: g_ben_band4_iv_id pay_input_values_f.input_value_id%type;
175: g_ben_band4_rate_iv_id pay_input_values_f.input_value_id%type;
176: g_ben_balance_iv_id pay_input_values_f.input_value_id%type;
177:
178: -- Used for LEGI and CAGR
179: TYPE bands_rec IS RECORD
180: (band_payment NUMBER,

Line 2125: pay_input_values_f piv_pst,

2121: piv_pet.input_value_id pmt_end_input_id
2122: --
2123: From pay_run_result_values prrv_pst,
2124: pay_run_result_values prrv_pet,
2125: pay_input_values_f piv_pst,
2126: pay_input_values_f piv_pet,
2127: pay_run_results prr_pst,
2128: pay_run_results prr_pet,
2129: pay_element_types_f peltf,

Line 2126: pay_input_values_f piv_pet,

2122: --
2123: From pay_run_result_values prrv_pst,
2124: pay_run_result_values prrv_pet,
2125: pay_input_values_f piv_pst,
2126: pay_input_values_f piv_pet,
2127: pay_run_results prr_pst,
2128: pay_run_results prr_pet,
2129: pay_element_types_f peltf,
2130: pay_assignment_actions pact,

Line 2577: pay_input_values_f i

2573: ,g_gi_info_band4_iv_id
2574: ,g_gi_info_start_date_iv_id
2575: ,g_gi_info_end_date_iv_id
2576: from pay_element_types_f e,
2577: pay_input_values_f i
2578: where e.element_name = 'FR_SICKNESS_GI_INFO'
2579: and e.legislation_code = 'FR'
2580: and e.element_type_id = i.element_type_id
2581: and p_effective_date between e.effective_start_date and e.effective_end_date

Line 2615: pay_input_values_f i

2611: ,g_gi_i_r_band4_iv_id
2612: ,g_gi_i_r_start_date_iv_id
2613: ,g_gi_i_r_end_date_iv_id
2614: from pay_element_types_f e,
2615: pay_input_values_f i
2616: where e.element_name = 'FR_SICKNESS_GI_INFO_RETRO'
2617: and e.legislation_code = 'FR'
2618: and e.element_type_id = i.element_type_id
2619: and p_effective_date between e.effective_start_date and e.effective_end_date

Line 3724: pay_input_values_f i

3720: ,g_ben_band4_iv_id
3721: ,g_ben_band4_rate_iv_id
3722: ,g_ben_balance_iv_id
3723: from pay_element_types_f e,
3724: pay_input_values_f i
3725: where e.element_name = 'FR_SICK_BENEFIT'
3726: and e.legislation_code = 'FR'
3727: and e.element_type_id = i.element_type_id
3728: and g_absence_calc.IJSS_payment_start_date between e.effective_start_date and e.effective_end_date

Line 4363: pay_input_values_f i

4359: select name,
4360: uom,
4361: substr(screen_entry_value,1,10) screen_entry_value
4362: from pay_element_entry_values_f ev,
4363: pay_input_values_f i
4364: where ev.element_entry_id = p_element_entry_id
4365: and ev.input_value_id + 0 = i.input_value_id
4366: and p_effective_date between
4367: ev.effective_start_date and ev.effective_end_date

Line 4375: l_name pay_input_values_f.name%TYPE;

4371:
4372:
4373: l_length_value NUMBER;
4374: l_concatenated_input varchar2(240);
4375: l_name pay_input_values_f.name%TYPE;
4376:
4377:
4378: BEGIN
4379:

Line 4402: pay_input_values_f i

4398: select name,
4399: uom,
4400: substr(result_value,1,10) result_value
4401: from pay_run_result_values rv,
4402: pay_input_values_f i
4403: where rv.run_result_id = p_run_result_id
4404: and rv.input_value_id + 0 = i.input_value_id
4405: order by display_sequence;
4406:

Line 4410: l_name pay_input_values_f.name%TYPE;

4406:
4407:
4408: l_length_value NUMBER;
4409: l_concatenated_input varchar2(240);
4410: l_name pay_input_values_f.name%TYPE;
4411:
4412:
4413: BEGIN
4414:

Line 4444: pay_input_values_f i

4440: ,p_effective_date in DATE) is
4441: select name,
4442: uom
4443: from
4444: pay_input_values_f i
4445: where i.element_type_id = p_element_type_id
4446: and p_effective_date between
4447: i.effective_start_date and i.effective_end_date
4448: order by display_sequence;

Line 4453: l_name pay_input_values_f.name%TYPE;

4449:
4450:
4451: l_length_value NUMBER;
4452: l_concatenated_input_name varchar2(240);
4453: l_name pay_input_values_f.name%TYPE;
4454:
4455:
4456: BEGIN
4457: