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.MO_UTILS dependencies on PER_ORGANIZATION_LIST

Line 369: -- security profile. The HR table per_organization_list is not

365: ELSE
366:
367: --
368: -- Check if this a view all or global view all organizations
369: -- security profile. The HR table per_organization_list is not
370: -- populated for view all or global view all organizations.
371: --
372: -- For a view all security profile within a business group,
373: -- the business group id is populated per_security_profiles.

Line 462: FROM per_organization_list per,

458: IF p_org_class = 'OPERATING_UNIT' THEN
459: BEGIN
460: SELECT 'Y'
461: INTO l_org_exists
462: FROM per_organization_list per,
463: hr_operating_units ou
464: WHERE per.organization_id = ou.organization_id
465: AND per.security_profile_id = l_security_profile_id
466: AND ou.organization_id = p_org_id;

Line 475: FROM per_organization_list per,

471: ELSIF p_org_class = 'HR_BG' THEN
472: BEGIN
473: SELECT 'Y'
474: INTO l_org_exists
475: FROM per_organization_list per,
476: per_business_groups bg
477: WHERE per.organization_id = bg.organization_id
478: AND per.security_profile_id = l_security_profile_id
479: AND bg.organization_id = p_org_id;