APPS.AR_CM_APP_LIB_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 148: , ar_payment_schedules ps

144: p_cm_unapp_amount,
145: p_cm_receipt_method_id
146: FROM
147: ra_customer_trx ct
148: , ar_payment_schedules ps
149: WHERE
150: ps.class = 'CM'
151: AND ct.customer_trx_id(+) = ps.customer_trx_id
152: AND ct.previous_customer_trx_id is null

Line 475: FROM ar_payment_schedules

471: (amount_due_remaining * -1)
472: INTO p_cm_gl_date,
473: p_cm_ps_id,
474: p_cm_unapp_amount
475: FROM ar_payment_schedules
476: WHERE customer_trx_id = l_customer_trx_id;
477: EXCEPTION
478: WHEN no_data_found THEN
479: IF PG_DEBUG in ('Y', 'C') THEN