APPS.FII_AR_UTIL_PKG dependencies on GL_SETS_OF_BOOKS

Line 707: gl_sets_of_books gsob

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

Line 728: gl_sets_of_books gsob

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:
732: ELSIF g_det_ou_lov=2 THEN

Line 736: gl_sets_of_books gsob

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
740: WHERE business_group_id = fii_ar_util_pkg.g_business_group_id) ;

Line 746: gl_sets_of_books gsob

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
750: WHERE security_profile_id = g_security_profile_id) ;

Line 757: gl_sets_of_books gsob

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:
761: END IF;

Line 767: gl_sets_of_books_v gsob

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: (
771: g_det_ou_lov=1 AND fsp.org_id = fsp.org_id