APPS.APRX_WT dependencies on GL_LEDGERS

Line 327: /*Bug 9897890 Added the tables hr_locations, gl_ledgers to the from clause

323:
324: --
325: -- Assign From Clause
326: --
327: /*Bug 9897890 Added the tables hr_locations, gl_ledgers to the from clause
328: Bug 10080788 Added a self join to table ap_invoice_distributions_all */
329:
330: fa_rx_util_pkg.From_Clause :=
331: 'po_vendors pv2,

Line 341: gl_ledgers gld'; --bug7621919 bug 9897890

337: ap_awt_groups atg,
338: ap_awt_tax_rates atr,
339: hr_organization_units hou,
340: hr_locations hrl,
341: gl_ledgers gld'; --bug7621919 bug 9897890
342:
343:
344: -- Assign Where Clause
345:

Line 348: /*Bug 9897890 Added joins with tables hr_locations, gl_ledgers to the where clause

344: -- Assign Where Clause
345:
346: -- Bug 2825570. Add filter on invoice_date between start and end dates.
347:
348: /*Bug 9897890 Added joins with tables hr_locations, gl_ledgers to the where clause
349: Bug 10080788 Added a self join to table ap_invoice_distributions_all */
350:
351: --begin bug12694504, changed the fa_rx_util_pkg.where_clase
352: /*

Line 419: gl_ledgers gld

415: CURSOR c_methods IS
416: SELECT UPPER(gld.SLA_LEDGER_CASH_BASIS_FLAG),
417: UPPER(secondary_accounting_method)
418: FROM ap_system_parameters asp,
419: gl_ledgers gld
420: WHERE asp.set_of_books_id = gld.ledger_id;
421:
422: first_acct_method gl_ledgers.SLA_LEDGER_CASH_BASIS_FLAG%TYPE;
423: second_acct_method ap_system_parameters.secondary_accounting_method%TYPE;

Line 422: first_acct_method gl_ledgers.SLA_LEDGER_CASH_BASIS_FLAG%TYPE;

418: FROM ap_system_parameters asp,
419: gl_ledgers gld
420: WHERE asp.set_of_books_id = gld.ledger_id;
421:
422: first_acct_method gl_ledgers.SLA_LEDGER_CASH_BASIS_FLAG%TYPE;
423: second_acct_method ap_system_parameters.secondary_accounting_method%TYPE;
424:
425: BEGIN
426: OPEN c_methods;