APPS.AR_INVOICE_API_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 857: UPDATE ar_payment_schedules ps

853: t_errmsg varchar2(1024);
854: BEGIN
855: temp_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
856: JG_ZZ_AR_AUTO_INVOICE.Trx_Num_Upd_Single_API(temp_customer_trx_id);
857: UPDATE ar_payment_schedules ps
858: SET trx_number = (SELECT ct.trx_number
859: FROM ra_customer_trx ct
860: WHERE ct.customer_trx_id =temp_customer_trx_id)
861: WHERE ps.customer_trx_id = temp_customer_trx_id;

Line 2088: ar_payment_schedules ps

2084: INTO x_amount_due_remaining,
2085: x_acctd_amount_due_remaining
2086: FROM ra_cust_Trx_types ctt,
2087: ra_customer_trx ct,
2088: ar_payment_schedules ps
2089: WHERE ctt.cust_Trx_type_id = ct.cust_trx_type_id
2090: AND ct.customer_trx_id = ps.customer_trx_id
2091: AND ctt.ACCOUNTING_AFFECT_FLAG = 'Y'
2092: AND ct.customer_trx_id = p_customer_trx_id;