APPS.ARW_CMREQ_COVER dependencies on AR_PAYMENT_SCHEDULES

Line 66: FROM ar_payment_schedules ps

62: /*4220382 ,12998583 */
63: /*
64: CURSOR ps_cur IS
65: SELECT payment_schedule_id , due_date , dispute_date , amount_in_dispute
66: FROM ar_payment_schedules ps
67: WHERE ps.customer_trx_id = p_customer_trx_id;
68: */
69:
70: /*12998583-M1*/

Line 74: FROM ar_payment_schedules ps

70: /*12998583-M1*/
71: CURSOR ps_cur IS
72: SELECT terms_sequence_number,payment_schedule_id , due_date , dispute_date , amount_in_dispute ,
73: amount_due_remaining,amount_due_original
74: FROM ar_payment_schedules ps
75: WHERE ps.customer_trx_id = p_customer_trx_id
76: ORDER BY terms_sequence_number ;
77:
78: BEGIN

Line 472: SELECT max(terms_sequence_number) into l_max_seq FROM AR_PAYMENT_SCHEDULES

468:
469: -- Put Invoice in Dispute before instantiation of Workflow Approval
470: /*4220382 */
471: /*12998583*/
472: SELECT max(terms_sequence_number) into l_max_seq FROM AR_PAYMENT_SCHEDULES
473: WHERE customer_trx_id=p_customer_trx_id;
474:
475: IF NVL(p_skip_workflow_flag,'N') = 'N' THEN
476: BEGIN

Line 503: UPDATE ar_payment_schedules set amount_in_dispute=l_run_dispute_amount,

499: IF NVL(l_dispute_amount,0) <> 0 THEN
500: IF (ps_rec.terms_sequence_number=l_max_seq) OR
501: (abs(ps_rec.amount_due_original) >= abs(NVL(ps_rec.amount_in_dispute,0)+NVL(l_dispute_amount,0)))
502: THEN
503: UPDATE ar_payment_schedules set amount_in_dispute=l_run_dispute_amount,
504: dispute_date=arp_global.last_update_date
505: where customer_trx_id=p_customer_trx_id and
506: terms_sequence_number=ps_rec.terms_sequence_number;
507: l_dispute_amount:=0;