DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 30: l_organization_name hr_organization_units.name%TYPE;

26: l_session_language varchar2(40);/* For MLS changes */
27: l_base_language varchar2(40); /*For MLS changes*/
28: l_inv_balance ap_invoices.invoice_amount%TYPE;
29: --l_start_date ap_invoices.invoice_date%TYPE;
30: l_organization_name hr_organization_units.name%TYPE;
31: l_sum_discount NUMBER; -- 3641604
32: l_paid_amount NUMBER; -- 2901541
33: --The cursor vendorinfo holds all the information about the vendor and vendor site
34:

Line 172: null in hr_organization_units

168: -- for bug#1721165 End TMANDA
169: /* For bug 2113775
170: Selecting the organization from gl_sets_of_books
171: in case of single org since the org_id will be
172: null in hr_organization_units
173: */
174:
175: Begin
176:

Line 179: FROM hr_organization_units

175: Begin
176:
177: SELECT name
178: INTO l_organization_name
179: FROM hr_organization_units
180: WHERE organization_id = FND_PROFILE.VALUE('ORG_ID');
181:
182: Exception
183: When no_data_found Then