APPS.ARP_GROUP_INV dependencies on AR_PAYMENT_SCHEDULES

Line 58: ar_payment_schedules ps,

54: ct.trx_date,
55: ct.customer_trx_id,
56: ct.org_id
57: FROM
58: ar_payment_schedules ps,
59: ra_customer_trx ct,
60: ra_cust_trx_types tt
61: WHERE
62: ct.cust_trx_type_id = tt.cust_trx_type_id

Line 77: old_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;

73: ORDER BY
74: ps.cons_inv_id,
75: ct.customer_trx_id;
76:
77: old_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
78: new_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
79:
80: old_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
81: new_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';

Line 78: new_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;

74: ps.cons_inv_id,
75: ct.customer_trx_id;
76:
77: old_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
78: new_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
79:
80: old_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
81: new_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;

Line 409: | Update ar_payment_schedules |

405: | PROCEDURE |
406: | update_ps |
407: | |
408: | DESCRIPTION |
409: | Update ar_payment_schedules |
410: | |
411: | SCOPE - PRIVATE |
412: | |
413: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 487: UPDATE ar_payment_schedules

483: -- Store the cons_inv_id in the PL/SQL table
484: --
485: g_cons_inv_id(c01_rec.customer_trx_id) := l_cons_inv_id;
486: --
487: UPDATE ar_payment_schedules
488: SET cons_inv_id = l_cons_inv_id
489: WHERE customer_trx_id = c01_rec.customer_trx_id;
490: --
491: l_tot_rec_updated := l_tot_rec_updated + SQL%ROWCOUNT;