APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on AP_INVOICES_ALL

Line 24: , pv_invoice_number ap_invoices_all.invoice_num%TYPE

20: , pn_location_id NUMBER
21: , pv_source VARCHAR2
22: , pn_vendor_id NUMBER
23: , pn_vendor_site_id NUMBER
24: , pv_invoice_number ap_invoices_all.invoice_num%TYPE
25: , pd_invoice_date DATE
26: , pd_as_of_date DATE
27: , p_process_message OUT NOCOPY varchar
28: , p_process_flag OUT NOCOPY varchar2

Line 122: FROM ap_invoices_all apa,

118: apa.vendor_id, apa.vendor_site_id,
119: jail.invoice_line_number,
120: jail.line_amount,
121: aid.accounting_date
122: FROM ap_invoices_all apa,
123: jai_ap_invoice_lines jail,
124: ap_invoice_distributions_all aid
125: WHERE
126: jail.invoice_id = apa.invoice_id

Line 181: FROM ap_invoices_all apa,

177: line.line_number,
178: line.amount line_amount,
179: line.match_type,
180: aid.accounting_date accounting_date
181: FROM ap_invoices_all apa,
182: ap_invoice_lines_all line,
183: ap_invoice_distributions_all aid,
184: po_line_locations_all po
185: WHERE

Line 231: FROM ap_invoices_all apa,

227: line.line_number,
228: line.amount,
229: line.match_type,
230: aid.accounting_date accounting_date
231: FROM ap_invoices_all apa,
232: ap_invoice_lines_all line,
233: jai_rcv_transactions rcv,
234: ap_invoice_distributions_all aid,
235: po_line_locations_all plla,--Added by qiong for bug 13435306

Line 444: from ap_invoices_all

440: AND aila.accounting_date <= cp_grace_date;
441:
442: CURSOR c_total_ap_amount(cp_invoice_id NUMBER) IS
443: select invoice_amount
444: from ap_invoices_all
445: where invoice_id = cp_invoice_id;
446:
447: CURSOR c_total_ar_amount(cp_invoice_id NUMBER) IS
448: SELECT amount_due_original