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_UTILITY dependencies on DUAL

Line 394: -- We do not want to select configuartions made for induvidual organizations.

390: --
391: -- The foll cursor selects all distinct org structures that have been
392: -- configured for the passed referenced rule set and business group . Ideally
393: -- this cursor should return one record only
394: -- We do not want to select configuartions made for induvidual organizations.
395: --
396: Cursor csr_org_struct is
397: Select distinct a.organization_structure_id
398: From pqh_rule_sets a

Line 418: from dual

414: start with ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
415: and organization_id_child = P_ORGANIZATION_ID
416: UNION
417: Select 0,p_organization_id
418: from dual
419: order by 1 asc;
420: --
421: l_proc varchar2(72) := g_package||'get_exist_org_level_cd';
422: l_oh_rule boolean := FALSE;

Line 629: From dual;

625: Procedure get_language_code( p_language_code OUT nocopy varchar2) is
626: --
627: Cursor c1 is
628: Select userenv('LANG')
629: From dual;
630: --
631: l_proc varchar2(72) := g_package||'get_language_code';
632: --
633: Begin