APPS.FII_AR_UTIL_PKG dependencies on PER_ORGANIZATION_LIST

Line 749: FROM per_organization_list

745: from ar_system_parameters_all fsp,
746: gl_sets_of_books gsob
747: where fsp.set_of_books_id = gsob.set_of_books_id
748: AND fsp.org_id in (SELECT organization_id
749: FROM per_organization_list
750: WHERE security_profile_id = g_security_profile_id) ;
751:
752: ELSIF g_det_ou_lov=4 THEN
753: l_org_id := nvl(fnd_profile.value('ORG_ID'), -1);

Line 785: FROM per_organization_list

781: OR (
782: g_det_ou_lov=3
783: AND fsp.org_id in (
784: SELECT organization_id
785: FROM per_organization_list
786: WHERE security_profile_id = g_security_profile_id
787: )
788: )
789: OR(

Line 1137: FROM per_organization_list per, ar_system_parameters_all ar, hr_all_organization_units hr

1133:
1134: IF g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
1135:
1136: l_org_from := ' ( SELECT per.organization_id,hr.name
1137: FROM per_organization_list per, ar_system_parameters_all ar, hr_all_organization_units hr
1138: WHERE per.security_profile_id = '||g_security_profile_id||'
1139: AND per.organization_id = ar.org_id
1140: AND per.organization_id = hr.organization_id '||l_org_specific_where||') p ';
1141:

Line 1144: FROM per_organization_list per, ar_system_parameters_all ar

1140: AND per.organization_id = hr.organization_id '||l_org_specific_where||') p ';
1141:
1142: ELSE
1143: l_org_from := ' (SELECT organization_id
1144: FROM per_organization_list per, ar_system_parameters_all ar
1145: WHERE per.security_profile_id = '||g_security_profile_id ||'
1146: AND per.organization_id = ar.org_id '||l_org_specific_where||') p ';
1147: END IF;
1148: