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 189: from pay_input_values_f piv

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

Line 202: from pay_input_values_f

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

Line 232: update pay_input_values_f

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

Line 393: from pay_input_values_f

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