APPS.FII_AR_UTIL_PKG dependencies on HR_OPERATING_UNITS

Line 739: FROM hr_operating_units

735: from ar_system_parameters_all fsp,
736: gl_sets_of_books gsob
737: where fsp.set_of_books_id = gsob.set_of_books_id
738: AND fsp.org_id in (SELECT organization_id
739: FROM hr_operating_units
740: WHERE business_group_id = fii_ar_util_pkg.g_business_group_id) ;
741:
742: ELSIF g_det_ou_lov=3 THEN
743: select distinct currency_code

Line 777: FROM hr_operating_units

773: OR (
774: g_det_ou_lov=2
775: AND fsp.org_id in (
776: SELECT organization_id
777: FROM hr_operating_units
778: WHERE business_group_id = fii_ar_util_pkg.g_business_group_id
779: )
780: )
781: OR (

Line 1100: FROM hr_operating_units per, ar_system_parameters_all ar, hr_all_organization_units hr

1096:
1097: IF g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
1098:
1099: l_org_from := ' ( SELECT per.organization_id,hr.name
1100: FROM hr_operating_units per, ar_system_parameters_all ar, hr_all_organization_units hr
1101: WHERE per.business_group_id = '||l_business_group_id ||'
1102: AND per.organization_id = ar.org_id
1103: AND per.organization_id = hr.organization_id '||l_org_specific_where||') p ';
1104:

Line 1107: FROM hr_operating_units per, ar_system_parameters_all ar

1103: AND per.organization_id = hr.organization_id '||l_org_specific_where||') p ';
1104:
1105: ELSE
1106: l_org_from := ' (SELECT per.organization_id
1107: FROM hr_operating_units per, ar_system_parameters_all ar
1108: WHERE per.business_group_id = '||l_business_group_id ||'
1109: AND per.organization_id = ar.org_id '||l_org_specific_where||') p ';
1110:
1111: END IF;

Line 1120: FROM hr_operating_units per, hr_all_organization_units hr

1116:
1117: IF g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' THEN
1118:
1119: l_org_from := ' ( SELECT per.organization_id,hr.name
1120: FROM hr_operating_units per, hr_all_organization_units hr
1121: WHERE per.organization_id = hr.organization_id '||l_org_specific_where||') p ';
1122:
1123: ELSE
1124: l_org_from := ' (SELECT per.organization_id

Line 1125: FROM hr_operating_units per

1121: WHERE per.organization_id = hr.organization_id '||l_org_specific_where||') p ';
1122:
1123: ELSE
1124: l_org_from := ' (SELECT per.organization_id
1125: FROM hr_operating_units per
1126: WHERE 1=1 '||l_org_specific_where||') p ';
1127:
1128: END IF;
1129: ELSE