APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 8: l_gl_period_name ap_invoice_distributions.period_name%TYPE := NULL; --bug 9593393

4: -------------------------------------------------------------------------------
5: -- Global Variables
6: -------------------------------------------------------------------------------
7:
8: l_gl_period_name ap_invoice_distributions.period_name%TYPE := NULL; --bug 9593393
9:
10: -- Logging Infra
11: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 444: --bug 9593393 l_gl_period_name ap_invoice_distributions.period_name%TYPE;

440: l_initial_awt Number;
441: l_tax_base_amt Number;
442: l_nit po_vendors.segment1%TYPE;
443: l_user_defd_formula_exists Boolean := FALSE;
444: --bug 9593393 l_gl_period_name ap_invoice_distributions.period_name%TYPE;
445: l_base_currency_code Varchar2(15);
446: debug_info Varchar2(100);
447: current_calling_sequence Varchar2(2000);
448:

Line 458: ap_invoice_distributions apid,

454: SELECT
455: distinct nvl(substr(apid.global_attribute2,1,30),pove.segment1) nit
456: FROM
457: ap_invoices apin,
458: ap_invoice_distributions apid,
459: po_vendors pove
460: WHERE
461: apid.invoice_id = apin.invoice_id
462: AND pove.vendor_id = apin.vendor_id

Line 482: ap_invoice_distributions apid,

478: nvl(apid.base_amount, apid.amount) line_amount
479: FROM
480: jl_zz_ap_inv_dis_wh jlwh,
481: ap_invoices apin,
482: ap_invoice_distributions apid,
483: jl_zz_ap_supp_awt_types jlst,
484: jl_zz_ap_sup_awt_cd jlsc,
485: jl_zz_ap_awt_types jlat,
486: po_vendors pove,

Line 896: ap_invoice_distributions apid,

892: jlat.user_defined_formula_flag user_defined_formula_flag
893: FROM
894: jl_zz_ap_inv_dis_wh jlwh,
895: ap_invoices apin,
896: ap_invoice_distributions apid,
897: jl_zz_ap_supp_awt_types jlst,
898: jl_zz_ap_sup_awt_cd jlsc,
899: jl_zz_ap_awt_types jlat,
900: po_vendors pove