APPS.FII_AR_UTIL_PKG dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 706: from ar_system_parameters_all fsp,

702: g_operating_unit := p_selected_operating_unit;
703:
704: select currency_code
705: into g_functional_currency_code
706: from ar_system_parameters_all fsp,
707: gl_sets_of_books gsob
708: where fsp.org_id = p_selected_operating_unit
709: and fsp.set_of_books_id = gsob.set_of_books_id;
710: END IF;

Line 727: from ar_system_parameters_all fsp,

723: IF g_det_ou_lov=1 THEN
724:
725: select distinct currency_code
726: into g_common_functional_currency
727: from ar_system_parameters_all fsp,
728: gl_sets_of_books gsob
729: where fsp.set_of_books_id = gsob.set_of_books_id
730: and fsp.org_id = fsp.org_id ;
731:

Line 735: from ar_system_parameters_all fsp,

731:
732: ELSIF g_det_ou_lov=2 THEN
733: select distinct currency_code
734: into g_common_functional_currency
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

Line 745: from ar_system_parameters_all fsp,

741:
742: ELSIF g_det_ou_lov=3 THEN
743: select distinct currency_code
744: into g_common_functional_currency
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

Line 756: from ar_system_parameters_all fsp,

752: ELSIF g_det_ou_lov=4 THEN
753: l_org_id := nvl(fnd_profile.value('ORG_ID'), -1);
754: select distinct currency_code
755: into g_common_functional_currency
756: from ar_system_parameters_all fsp,
757: gl_sets_of_books gsob
758: where fsp.set_of_books_id = gsob.set_of_books_id
759: AND fsp.org_id = l_org_id ;
760:

Line 766: from ar_system_parameters_all fsp,

762:
763: /*
764: select distinct currency_code
765: into g_common_functional_currency
766: from ar_system_parameters_all fsp,
767: gl_sets_of_books_v gsob
768: where fsp.set_of_books_id = gsob.set_of_books_id
769: AND (
770: (

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 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: