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 AP_SYSTEM_PARAMETERS_ALL

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

Line 355: FROM per_organization_list per, ap_system_parameters_all ap

351: ELSE
352:
353: SELECT COUNT(1)
354: INTO l_org_count
355: FROM per_organization_list per, ap_system_parameters_all ap
356: WHERE per.security_profile_id = g_security_profile_id
357: AND per.organization_id = ap.org_id;
358:
359: /* Case 2: User has access to more than 5 organizations. */

Line 361: p_org_where := ' and f.org_id in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = :SEC_ID and per.organization_id = ap.org_id) ';

357: AND per.organization_id = ap.org_id;
358:
359: /* Case 2: User has access to more than 5 organizations. */
360: IF l_org_count > 5 THEN
361: p_org_where := ' and f.org_id in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = :SEC_ID and per.organization_id = ap.org_id) ';
362:
363: /* Case 3: User has access to 2-5 organizations. */
364: ELSIF (l_org_count >= 2 and l_org_count <= 5) THEN
365: FOR C1_Rec in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = g_security_profile_id and per.organization_id = ap.org_id)

Line 365: FOR C1_Rec in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = g_security_profile_id and per.organization_id = ap.org_id)

361: p_org_where := ' and f.org_id in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = :SEC_ID and per.organization_id = ap.org_id) ';
362:
363: /* Case 3: User has access to 2-5 organizations. */
364: ELSIF (l_org_count >= 2 and l_org_count <= 5) THEN
365: FOR C1_Rec in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = g_security_profile_id and per.organization_id = ap.org_id)
366: LOOP
367: l_org_list := l_org_list||C1_Rec.organization_id||',';
368: END LOOP;
369: l_org_list := substr(l_org_list, 1, length(l_org_list)-1);

Line 374: SELECT organization_id INTO l_org_id FROM per_organization_list per, ap_system_parameters_all ap WHERE security_profile_id = g_security_profile_id AND per.organization_id = ap.org_id;

370: p_org_where := ' and f.org_id in ('||l_org_list||') ';
371:
372: /* CASE 4: User has access to a single organization. */
373: ELSIF l_org_count = 1 THEN
374: SELECT organization_id INTO l_org_id FROM per_organization_list per, ap_system_parameters_all ap WHERE security_profile_id = g_security_profile_id AND per.organization_id = ap.org_id;
375: p_org_where := ' and f.org_id = ' || l_org_id;
376: /* CASE 5: User has access to no organizations. */
377: ELSIF l_org_count = 0 THEN
378: p_org_where := ' and f.org_id = -1 ';