APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on AP_INVOICES_V

Line 1786: --* Tables Used : ap_invoices_v VIEW, SELECT *--

1782: --* : g_user_id READ *--
1783: --* Called from : validate_po *--
1784: --* Calls : fv_utility.debug_mesg *--
1785: --* : fv_utility.log_mesg *--
1786: --* Tables Used : ap_invoices_v VIEW, SELECT *--
1787: --* : ap_recurring_payments_v VIEW, SELECT *--
1788: --* : ap_invoices VIEW, SELECT *--
1789: --* : fv_ipac_recurring_inv SELECT, INSERT *--
1790: --* Logic : Already existing code *--

Line 1811: l_approval_code ap_invoices_v.approval_status_lookup_code%TYPE;

1807: l_module_name VARCHAR2(200);
1808: l_location VARCHAR2(200);
1809:
1810: l_invoice_id ap_invoices.invoice_id%TYPE;
1811: l_approval_code ap_invoices_v.approval_status_lookup_code%TYPE;
1812: l_code VARCHAR2(1);
1813:
1814: CURSOR invoice_cur
1815: (

Line 1823: FROM ap_invoices_v ai,

1819: )
1820: IS
1821: SELECT ai.invoice_id,
1822: ai.approval_status_lookup_code
1823: FROM ap_invoices_v ai,
1824: ap_recurring_payments_v arp
1825: WHERE arp.recurring_payment_id = ai.recurring_payment_id
1826: AND arp.set_of_books_id = ai.set_of_books_id
1827: AND arp.po_number = c_po_num

Line 1847: FROM ap_invoices_v ai,

1843: AND arp.line_num = NVL(c_po_line_num,1))
1844: UNION
1845: SELECT DISTINCT ai.invoice_id,
1846: ai.approval_status_lookup_code
1847: FROM ap_invoices_v ai,
1848: ap_invoice_distributions_v ali
1849: WHERE ali.po_number = c_po_num
1850: AND ai.invoice_id = ali.invoice_id
1851: AND ali.po_line_number = NVL(c_po_line_num,1)

Line 1858: FROM ap_invoices_v ai1,

1854: AND ai.set_of_books_id = g_set_of_books_id
1855: AND ai.source <> 'RECURRING INVOICE'
1856: AND ai.invoice_type_lookup_code = 'STANDARD'
1857: AND ai.invoice_date = (SELECT MIN(invoice_date)
1858: FROM ap_invoices_v ai1,
1859: ap_invoice_distributions_v ali1
1860: WHERE ali1.po_number = c_po_num
1861: AND ai1.invoice_id = ali1.invoice_id
1862: AND ali1.po_line_number = NVL(c_po_line_num,1)