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_TEM_BUS dependencies on FND_TERRITORIES_VL

Line 331: from fnd_territories_vl a

327: l_tat_leg_code varchar2(10);
328: --
329: cursor c1 is
330: select 'x'
331: from fnd_territories_vl a
332: where a.territory_code = p_legislation_code;
333: --
334: cursor c2(p_template_id number) is
335: select legislation_code

Line 356: -- fnd_territories_vl table

352: <> nvl(pqh_tem_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
353: or not l_api_updating) then
354: --
355: -- check if legislation_code value exists in
356: -- fnd_territories_vl table
357: --
358: if p_legislation_code is not null then
359: open c1;
360: --

Line 366: -- raise error as FK does not relate to PK in fnd_territories_vl

362: if c1%notfound then
363: --
364: close c1;
365: --
366: -- raise error as FK does not relate to PK in fnd_territories_vl
367: -- table.
368: --
369: pqh_tem_shd.constraint_error('PQH_TEMPLATES_FK2');
370: --