APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on AP_INVOICE_DISTRIBUTIONS

Line 371: FROM ap_invoice_distributions_all apid,

367: apid.set_of_books_id,
368: apid.org_id,
369: apid.amount, -- added this for 5466103
370: glpv.chart_of_accounts_id
371: FROM ap_invoice_distributions_all apid,
372: gl_ledgers_public_v glpv
373: WHERE apid.invoice_id = p_invoice_id
374: AND apid.set_of_books_id = glpv.ledger_id;
375:

Line 414: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE;

410: l_dist_sob_rec dist_sob_csr%ROWTYPE;
411: l_tas_rec treasury_symbol_csr%ROWTYPE;
412: -- l_amt_id_rec payid_amt_csr%ROWTYPE;
413:
414: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.dist_code_combination_id%TYPE;
415: l_segment_column BOOLEAN;
416: apps_id NUMBER(10) := 101;
417: l_flex_code VARCHAR2(20) := 'GL#';
418: l_seg_name VARCHAR2(30);