APPS.JAI_TAX_PROCESSING_PKG dependencies on AP_PAYMENT_SCHEDULES

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 2033: inv_ps_rec AP_PAYMENT_SCHEDULES%ROWTYPE;

2029: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;
2030: inv_rec AP_INVOICES_ALL%ROWTYPE;
2031: inv_line_rec AP_INVOICE_LINES_ALL%ROWTYPE;
2032: inv_dist_rec AP_INVOICE_DISTRIBUTIONS_ALL%ROWTYPE;
2033: inv_ps_rec AP_PAYMENT_SCHEDULES%ROWTYPE;
2034: lv_action VARCHAR2(100);
2035: lv_return_code VARCHAR2(100);
2036: lv_return_message VARCHAR2(2000);
2037: lv_process_flag varchar2(2);

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;