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

Line 155: FROM hr_operating_units

151: OR (
152: g_det_ou_lov=2
153: AND fsp.org_id in (
154: SELECT organization_id
155: FROM hr_operating_units
156: WHERE business_group_id = fii_pmv_util.g_business_group_id
157: )
158: )
159: OR (

Line 323: FROM hr_operating_units hr, ap_system_parameters_all ap

319: p_org_where := ' ';
320: ELSIF l_all_org_flag = 'Y' and l_business_group_id is NOT NULL THEN
321:
322: SELECT COUNT(1) INTO l_org_count
323: FROM hr_operating_units hr, ap_system_parameters_all ap
324: WHERE hr.business_group_id = l_business_group_id
325: AND hr.organization_id = ap.org_id;
326:
327: /* Case 2: User has access to more than 5 organizations. */

Line 329: p_org_where := ' and f.org_id in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = :BUSINESS_GROUP and hr.organization_id = ap.org_id) ';

325: AND hr.organization_id = ap.org_id;
326:
327: /* Case 2: User has access to more than 5 organizations. */
328: IF l_org_count > 5 THEN
329: p_org_where := ' and f.org_id in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = :BUSINESS_GROUP and hr.organization_id = ap.org_id) ';
330:
331: /* Case 3: User has access to 2-5 organizations. */
332: ELSIF (l_org_count >= 2 and l_org_count <= 5) THEN
333: FOR C1_Rec in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = l_business_group_id and hr.organization_id = ap.org_id)

Line 333: FOR C1_Rec in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = l_business_group_id and hr.organization_id = ap.org_id)

329: p_org_where := ' and f.org_id in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = :BUSINESS_GROUP and hr.organization_id = ap.org_id) ';
330:
331: /* Case 3: User has access to 2-5 organizations. */
332: ELSIF (l_org_count >= 2 and l_org_count <= 5) THEN
333: FOR C1_Rec in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = l_business_group_id and hr.organization_id = ap.org_id)
334: LOOP
335: l_org_list := l_org_list||C1_Rec.organization_id||',';
336: END LOOP;
337: l_org_list := substr(l_org_list, 1, length(l_org_list)-1);

Line 342: SELECT organization_id INTO l_org_id FROM hr_operating_units hr, ap_system_parameters_all ap WHERE hr.business_group_id = l_business_group_id AND hr.organization_id = ap.org_id;

338: p_org_where := ' and f.org_id in ('||l_org_list||') ';
339:
340: /* CASE 4: User has access to a single organization. */
341: ELSIF l_org_count = 1 THEN
342: SELECT organization_id INTO l_org_id FROM hr_operating_units hr, ap_system_parameters_all ap WHERE hr.business_group_id = l_business_group_id AND hr.organization_id = ap.org_id;
343: p_org_where := ' and f.org_id = ' || l_org_id;
344:
345: /* CASE 5: User has access to no organizations. */
346: ELSIF l_org_count = 0 THEN