APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 22: l_organization_name hr_organization_units.name%TYPE;

18:
19: l_amount_remaining ap_invoices.invoice_amount%TYPE;
20: l_session_language VARCHAR2(40);/* For MLS changes */
21: l_base_language VARCHAR2(40); /*For MLS changes*/
22: l_organization_name hr_organization_units.name%TYPE;
23: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE;
24: l_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
25: l_invoice_amount ap_invoices_all.invoice_amount%TYPE;
26: l_payment_amount ap_invoices_all.amount_paid%TYPE;

Line 125: null in hr_organization_units*/

121:
122: /* For bug 2113775
123: Selecting the organization from gl_sets_of_books
124: in case of single org since the org_id will be
125: null in hr_organization_units*/
126: BEGIN
127:
128: SELECT name
129: INTO l_organization_name

Line 130: FROM hr_organization_units

126: BEGIN
127:
128: SELECT name
129: INTO l_organization_name
130: FROM hr_organization_units
131: WHERE organization_id = FND_PROFILE.VALUE('ORG_ID');
132:
133: EXCEPTION
134: WHEN no_data_found THEN