APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on GL_SETS_OF_BOOKS

Line 193: gl_sets_of_books SOB

189: *----------------------------------------------------*/
190: SELECT NVL(SLA_LEDGER_CASH_BASIS_FLAG, 'N')
191: INTO l_cash_basis
192: FROM ap_system_parameters_all ASP,
193: gl_sets_of_books SOB
194: WHERE asp.org_id = x_org_id
195: AND asp.set_of_books_id = sob.set_of_books_id;
196:
197: /*---------------------------------------------------

Line 486: gl_sets_of_books SOB,

482:
483: SELECT NVL(sla_ledger_cash_basis_flag, 'N')
484: INTO l_cash_basis
485: FROM ap_system_parameters ASP,
486: gl_sets_of_books SOB,
487: ap_invoices AI
488: WHERE AI.invoice_id = x_invoice_id
489: AND AI.org_id = ASP.org_id
490: AND asp.set_of_books_id = sob.set_of_books_id;

Line 1364: gl_sets_of_books gsob

1360: ap_invoices AI,
1361: ap_suppliers PV,
1362: po_distributions PD,
1363: ap_system_parameters ap,
1364: gl_sets_of_books gsob
1365: WHERE AI.invoice_id = X_invoice_id
1366: AND AID.invoice_id = AI.invoice_id
1367: AND AID.invoice_line_number =
1368: NVL(X_line_number, invoice_line_number)

Line 3445: FROM gl_sets_of_books

3441: BEGIN
3442:
3443: SELECT chart_of_accounts_id
3444: INTO l_coa_id
3445: FROM gl_sets_of_books
3446: WHERE set_of_books_id = X_Sob_Id;
3447:
3448: -- Get the segments of the two given accounts
3449: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',

Line 3499: FROM gl_sets_of_books

3495: BEGIN
3496:
3497: SELECT chart_of_accounts_id
3498: INTO l_coa_id
3499: FROM gl_sets_of_books
3500: WHERE set_of_books_id = X_Sob_Id;
3501:
3502: -- Get the delimiter
3503: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_coa_id);

Line 3818: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

3814: AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
3815: l_dist_ccid
3816: AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
3817: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
3818: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
3819: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3820: l_assets_tracking_flag
3821: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3822: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

Line 3963: FROM ap_system_parameters ap, gl_sets_of_books gsob

3959: debug_info := 'Get system information';
3960: BEGIN
3961: SELECT gsob.chart_of_accounts_id, ap.base_currency_code
3962: INTO l_chart_of_accounts_id, l_base_currency_code
3963: FROM ap_system_parameters ap, gl_sets_of_books gsob
3964: WHERE ap.set_of_books_id = gsob.set_of_books_id
3965: AND ap.set_of_books_id = l_invoice_line_rec.set_of_books_id;
3966:
3967: EXCEPTION

Line 4744: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

4740: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
4741: X_vendor_id IN NUMBER,
4742: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
4743: X_sob_id IN AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,
4744: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
4745: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
4746: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
4747: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
4748: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

Line 5338: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

5334: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
5335: l_org_id AP_INVOICE_LINES.ORG_ID%TYPE;
5336: l_sob_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE;
5337: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5338: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5339: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;

Line 5755: FROM ap_system_parameters ap, gl_sets_of_books gsob

5751: SELECT gsob.chart_of_accounts_id, ap.base_currency_code,
5752: ap.allow_flex_override_flag
5753: INTO l_chart_of_accounts_id, l_base_currency_code,
5754: l_allow_po_override
5755: FROM ap_system_parameters ap, gl_sets_of_books gsob
5756: WHERE ap.set_of_books_id = gsob.set_of_books_id;
5757:
5758: l_pa_allows_overrides :=
5759: FND_PROFILE.VALUE('PA_ALLOW_FLEXBUILDER_OVERRIDES');