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.PQP_NL_PENSION_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 191: from pay_input_values_f piv

187: ,c_iv_name varchar2) is
188: select input_value_id
189: ,piv.name
190: ,piv.element_type_id
191: from pay_input_values_f piv
192: ,pay_element_types_f pet
193: where element_name = c_ele_name
194: and piv.element_type_id = pet.element_type_id
195: and (piv.business_group_id = p_business_group_id or

Line 204: from pay_input_values_f

200:
201: cursor csr_updinput(c_ip_id number
202: ,c_element_type_id number) is
203: select rowid
204: from pay_input_values_f
205: where input_value_id = c_ip_id
206: and element_type_id = c_element_type_id
207: for update nowait;
208:

Line 234: update pay_input_values_f

230: exit when csr_updinput%notfound;
231: --
232: hr_utility.set_location (l_proc_name, 30);
233: --
234: update pay_input_values_f
235: set default_value = p_def_value
236: where rowid = csr_updinput_rec.rowid;
237: end loop;
238: close csr_updinput;

Line 395: from pay_input_values_f

391: --
392: cursor csr_ipv (c_ele_typeid number
393: ,c_effective_date date) is
394: select input_value_id
395: from pay_input_values_f
396: where element_type_id = c_ele_typeid
397: and business_group_id = p_business_group_id
398: and name = 'Pay Value'
399: and c_effective_date between effective_start_date