APPS.PA_TRX_IMPORT dependencies on AP_INVOICES_ALL

Line 11018: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

11014: l_project_id NUMBER(15);
11015: l_base_qv NUMBER;
11016: l_base_av NUMBER;
11017: l_period_year pa_bc_packets.period_year%type; --REL12
11018: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
11019: l_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
11020:
11021: -- R12 AP lines uptake : Prepayment changes :Cursor to fetch AP related details.
11022: CURSOR C_ap_details (p_invoice_id NUMBER,

Line 12663: ap_invoices_all inv

12659: AND PayDIST.invoice_payment_id = p_sys_ref4
12660: AND EXISTS
12661: (SELECT 1
12662: FROM ap_invoice_payments Pay,
12663: ap_invoices_all inv
12664: WHERE pay.invoice_payment_id = p_sys_ref4
12665: AND pay.invoice_id = inv.invoice_id
12666: AND NVL(pay.exchange_rate,0) <> NVL(inv.exchange_rate,0));
12667:

Line 13066: FROM ap_invoices_all A, ap_invoice_distributions_all aid

13062: WHERE po_distribution_id = p_po_dist_id;
13063:
13064: CURSOR c_get_vendor_id IS
13065: SELECT a.vendor_id
13066: FROM ap_invoices_all A, ap_invoice_distributions_all aid
13067: WHERE A.invoice_id = aid.invoice_id
13068: AND A.invoice_id = p_sys_ref2
13069: AND aid.invoice_distribution_id = p_sys_ref5
13070: UNION /* Added for bug 13859614 */

Line 13072: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid

13068: AND A.invoice_id = p_sys_ref2
13069: AND aid.invoice_distribution_id = p_sys_ref5
13070: UNION /* Added for bug 13859614 */
13071: SELECT a.vendor_id
13072: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid
13073: WHERE A.invoice_id = aid.invoice_id
13074: AND A.invoice_id = p_sys_ref2
13075: AND aid.invoice_distribution_id = p_sys_ref5;
13076:

Line 13190: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/

13186: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
13187: L_RAW_BC_PACKET_ID NUMBER;
13188: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
13189: l_po_line_id po_distributions_all.po_line_id%TYPE;
13190: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/
13191:
13192: CURSOR c_curr_raw_pkt IS
13193: SELECT bc_packet_id
13194: FROM pa_bc_packets

Line 13980: FROM ap_invoices_all A, ap_invoice_distributions_all aid

13976:
13977: /*bug 13601768*/
13978: CURSOR c_get_vendor_id IS
13979: SELECT a.vendor_id
13980: FROM ap_invoices_all A, ap_invoice_distributions_all aid
13981: WHERE A.invoice_id = aid.invoice_id
13982: AND A.invoice_id = p_sys_ref2
13983: AND aid.invoice_distribution_id = p_sys_ref5
13984: UNION /* Added for bug 13859614 */

Line 13986: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid

13982: AND A.invoice_id = p_sys_ref2
13983: AND aid.invoice_distribution_id = p_sys_ref5
13984: UNION /* Added for bug 13859614 */
13985: SELECT a.vendor_id
13986: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid
13987: WHERE A.invoice_id = aid.invoice_id
13988: AND A.invoice_id = p_sys_ref2
13989: AND aid.invoice_distribution_id = p_sys_ref5;
13990:

Line 14069: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/

14065: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14066: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14067: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
14068: l_po_line_id po_distributions_all.po_line_id%TYPE;
14069: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/
14070:
14071: BEGIN
14072:
14073: IF PG_DEBUG = 'Y' THEN