APPS.JAI_TAX_PROCESSING_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 2004: from ap_payment_schedules_all apsa

2000: -- cursor to get invoice payment schedules
2001: cursor c_get_inv_pss(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE)
2002: IS
2003: select apsa.*
2004: from ap_payment_schedules_all apsa
2005: where apsa.invoice_id = cp_trx_id;
2006:
2007: cursor c_jai_ap_tds_thhold_trxs(cp_invoice_id number) IS
2008: select parent_inv_payment_priority

Line 2102: update ap_payment_schedules_all

2098: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;
2099: close c_jai_ap_tds_thhold_trxs;
2100:
2101: IF ln_parent_inv_payment_priority is not null THEN
2102: update ap_payment_schedules_all
2103: set payment_priority = ln_parent_inv_payment_priority
2104: where payment_num = inv_ps_rec.payment_num
2105: and invoice_id = inv_rec.invoice_id;
2106: END IF;