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 PER_ORGANIZATION_LIST

Line 163: FROM per_organization_list

159: OR (
160: g_det_ou_lov=3
161: AND fsp.org_id in (
162: SELECT organization_id
163: FROM per_organization_list
164: WHERE security_profile_id = g_sec_profile
165: )
166: )
167: OR(

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 ';