DBA Data[Home] [Help]

APPS.JE_BE_CSSR_PKG dependencies on GL_LEDGERS

Line 320: l_ledger_id gl_ledgers.ledger_id%type;

316: l_level number(15);
317: l_var varchar2(50);
318: l_reporting_level varchar2(30);
319: l_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%TYPE;
320: l_ledger_id gl_ledgers.ledger_id%type;
321: l_bsv varchar2(30);
322:
323: -- ccid and sob
324: cursor get_coa_id (p_sob gl_sets_of_books.set_of_books_id%type)

Line 637: gl_ledgers glr

633: FROM ap_invoices_all ap_inv,
634: ap_supplier_sites_all ven ,
635: ap_invoice_distributions_all ap_dist ,
636: fnd_lookup_values lv,
637: gl_ledgers glr
638: WHERE ap_inv.legal_entity_id = :p_legal_entity_id1
639: AND ap_inv.vendor_site_id = ven.vendor_site_id
640: AND ap_dist.invoice_id = ap_inv.invoice_id
641: AND glr.ledger_id = ap_inv.set_of_books_id

Line 673: gl_ledgers glr

669: hz_parties parties,
670: hz_party_sites hz_ps,
671: hz_locations hzl,
672: fnd_lookup_values lv,
673: gl_ledgers glr
674: WHERE trx.legal_entity_id = :p_legal_entity_id2
675: AND gld.customer_trx_id = trx.customer_trx_id
676: AND trx.bill_to_customer_id = hz_cust.cust_account_id
677: AND hz_cust.party_id = parties.party_id