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.PQH_RER_BUS dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 307: select null from PQH_CRITERIA_RATE_ELEMENTS a

303: l_api_updating boolean;
304: l_dummy varchar2(1);
305:
306: cursor c1 is
307: select null from PQH_CRITERIA_RATE_ELEMENTS a
308: where a.criteria_rate_element_id = p_criteria_rate_element_id;
309:
310: --
311: Begin

Line 326: -- PQH_CRITERIA_RATE_ELEMENTS table

322: <> nvl(pqh_rer_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)
323: or not l_api_updating) then
324: --
325: -- check if criteria_rate_element_id value exists in
326: -- PQH_CRITERIA_RATE_ELEMENTS table
327: --
328: open c1;
329: --
330:

Line 338: -- raise error as FK does not relate to PK in PQH_CRITERIA_RATE_ELEMENTS

334: if c1%notfound then
335: --
336: close c1;
337: --
338: -- raise error as FK does not relate to PK in PQH_CRITERIA_RATE_ELEMENTS
339: -- table.
340: --
341: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK1');
342: --