APPS.AP_PPA_PKG dependencies on AP_INVOICES

Line 264: ap_invoices i,

260: i.terms_date,
261: i.goods_received_date
262: FROM ap_terms t,
263: ap_invoice_distributions d,
264: ap_invoices i,
265: ap_payment_schedules ps
266: WHERE i.payment_status_flag = 'N'
267: AND ps.amount_remaining > 0
268: AND ps.invoice_id = i.invoice_id

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

584: to_date(nvl(rt.transaction_date,
585: nvl(i.goods_received_date +
586: nvl(p_receipt_acc_days,0),p_inv_date))))))
587: INTO p_start_date
588: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,
589: ap_invoice_distributions ad, po_distributions_ap_v d
590: WHERE i.invoice_id = p_invoice_id
591: AND i.invoice_id = ad.invoice_id(+)
592: AND ad.po_distribution_id = d.po_distribution_id

Line 681: FROM ap_invoices i

677: i.terms_date,
678: nvl(i.goods_received_date +
679: nvl(p_receipt_acc_days,0), p_inv_date))
680: INTO p_start_date
681: FROM ap_invoices i
682: WHERE i.invoice_id = p_invoice_id;
683:
684: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
685:

Line 1061: FROM ap_invoices

1057: amount_applicable_to_discount
1058: INTO p_invoice_amount,
1059: p_pay_curr_invoice_amount, -- R11: Xcurr
1060: p_amount_applicable_to_disc
1061: FROM ap_invoices
1062: WHERE invoice_id = p_invoice_id;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN

Line 1202: FROM ap_invoices

1198: --
1199:
1200: SELECT payment_currency_code
1201: INTO l_pay_curr_code
1202: FROM ap_invoices
1203: WHERE invoice_id = p_invoice_id;
1204:
1205: UPDATE ap_payment_schedules
1206: SET due_date = p_ppa_due_date,

Line 1365: FROM ap_invoices

1361: SELECT nvl(minimum_accountable_unit,0), precision
1362: INTO l_min_unit, l_precision
1363: FROM fnd_currencies
1364: WHERE currency_code = ( SELECT payment_currency_code -- R11: Xcurr
1365: FROM ap_invoices
1366: WHERE invoice_id = p_invoice_id);
1367:
1368: l_debug_info := 'l_min_unit '||l_min_unit||'l_precision '||l_precision;
1369: print(l_debug_info, l_debug_loc); --bug 9162299

Line 1678: FROM ap_invoices

1674:
1675: -- get payment currency code for rounding
1676: SELECT payment_currency_code, org_id
1677: INTO l_pay_curr_code, l_org_id /* Bug 3700128. MOAC Project */
1678: FROM ap_invoices
1679: WHERE invoice_id = p_invoice_id;
1680:
1681:
1682: INSERT INTO ap_payment_schedules

Line 2005: FROM ap_invoices

2001: WHERE invoice_id = P_Invoice_Id;
2002:
2003: SELECT nvl(pay_curr_invoice_amount,invoice_amount) pay_curr_invoice_amount
2004: INTO l_pay_curr_invoice_amount
2005: FROM ap_invoices
2006: WHERE invoice_id = p_invoice_id;
2007:
2008: -- Adjust Payment Schedules for rounding errors
2009: IF (l_pay_sched_total <> l_Pay_Curr_Invoice_Amount) THEN