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.IEX_STRATEGY_CNT_PUB dependencies on HR_OPERATING_UNITS

Line 2415: SELECT organization_id from hr_operating_units where

2411: l_con_update_re_st boolean;
2412: l_c_org_count number := 0;
2413: -- end added by snuthala for bug 10221334 on 21-10-2010
2414: CURSOR c_org IS
2415: SELECT organization_id from hr_operating_units where
2416: mo_global.check_access(organization_id) = 'Y'
2417: AND organization_id = nvl(P_ORG_ID,organization_id);
2418:
2419: -- Start for bug 8708271 multi level strategy

Line 2455: from hr_operating_units a, IEX_app_preferences_b b

2451: org_id = p_org_id and enabled_flag ='Y';
2452:
2453: CURSOR c_check_ou_methods (p_org_id number) IS
2454: SELECT COUNT(1)
2455: from hr_operating_units a, IEX_app_preferences_b b
2456: where mo_global.check_access(a.organization_id) = 'Y'
2457: and a.organization_id = b.org_id
2458: and b.collections_method = 'STRATEGIES'
2459: and b.enabled_flag ='Y'

Line 4082: vPLSQL2 := 'SELECT organization_id,name from hr_operating_units where '||

4078: end loop;
4079: close c_mou_account;
4080: -- End adding by gnramasa for bug 8833868 3-Sep-09
4081: -- Start added by snuthala for bug 10221334 on 21-10-2010
4082: vPLSQL2 := 'SELECT organization_id,name from hr_operating_units where '||
4083: ' mo_global.check_access(organization_id) = ''Y''';
4084: if p_org_id IS NOT NULL then
4085: vPLSQL2 := vPLSQL2 || ' and organization_id = nvl(' || p_org_id ||' ,organization_id) ';
4086: end if;