APPS.AP_PPA_PKG dependencies on AP_INVOICES

Line 242: ap_invoices i,

238: i.terms_date,
239: i.goods_received_date
240: FROM ap_terms t,
241: ap_invoice_distributions d,
242: ap_invoices i,
243: ap_payment_schedules ps
244: WHERE i.payment_status_flag = 'N'
245: AND ps.amount_remaining > 0
246: AND ps.invoice_id = i.invoice_id

Line 563: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,

559: to_date(nvl(rt.transaction_date,
560: nvl(i.goods_received_date +
561: nvl(p_receipt_acc_days,0),p_inv_date))))))
562: INTO p_start_date
563: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,
564: ap_invoice_distributions ad, po_distributions_ap_v d
565: WHERE i.invoice_id = p_invoice_id
566: AND i.invoice_id = ad.invoice_id(+)
567: AND ad.po_distribution_id = d.po_distribution_id

Line 656: FROM ap_invoices i

652: i.terms_date,
653: nvl(i.goods_received_date +
654: nvl(p_receipt_acc_days,0), p_inv_date))
655: INTO p_start_date
656: FROM ap_invoices i
657: WHERE i.invoice_id = p_invoice_id;
658:
659: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
660:

Line 1020: FROM ap_invoices

1016: amount_applicable_to_discount
1017: INTO p_invoice_amount,
1018: p_pay_curr_invoice_amount, -- R11: Xcurr
1019: p_amount_applicable_to_disc
1020: FROM ap_invoices
1021: WHERE invoice_id = p_invoice_id;
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN

Line 1161: FROM ap_invoices

1157: --
1158:
1159: SELECT payment_currency_code
1160: INTO l_pay_curr_code
1161: FROM ap_invoices
1162: WHERE invoice_id = p_invoice_id;
1163:
1164: UPDATE ap_payment_schedules
1165: SET due_date = p_ppa_due_date,

Line 1322: FROM ap_invoices

1318: SELECT nvl(minimum_accountable_unit,0), precision
1319: INTO l_min_unit, l_precision
1320: FROM fnd_currencies
1321: WHERE currency_code = ( SELECT payment_currency_code -- R11: Xcurr
1322: FROM ap_invoices
1323: WHERE invoice_id = p_invoice_id);
1324:
1325: l_debug_info := 'Get calendar for terms lines';
1326: --

Line 1601: FROM ap_invoices

1597:
1598: -- get payment currency code for rounding
1599: SELECT payment_currency_code, org_id
1600: INTO l_pay_curr_code, l_org_id /* Bug 3700128. MOAC Project */
1601: FROM ap_invoices
1602: WHERE invoice_id = p_invoice_id;
1603:
1604:
1605: INSERT INTO ap_payment_schedules

Line 1914: FROM ap_invoices

1910: WHERE invoice_id = P_Invoice_Id;
1911:
1912: SELECT nvl(pay_curr_invoice_amount,invoice_amount) pay_curr_invoice_amount
1913: INTO l_pay_curr_invoice_amount
1914: FROM ap_invoices
1915: WHERE invoice_id = p_invoice_id;
1916:
1917: -- Adjust Payment Schedules for rounding errors
1918: IF (l_pay_sched_total <> l_Pay_Curr_Invoice_Amount) THEN