APPS.ARP_COLL_IND dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 174: FROM ar_payment_schedules_all ps,

170: )
171: + Get_Adj_For_Tot_Rec_GL(ps.payment_schedule_id,pend_date)
172: )
173: INTO tot_rec
174: FROM ar_payment_schedules_all ps,
175: ra_customer_trx_all trx
176: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
177: AND ps.payment_schedule_id <> -1
178: AND ps.customer_trx_id = trx.customer_trx_id

Line 261: FROM ar_payment_schedules_all ps,

257: SELECT sum(Get_Apps_Total_GL(ps.payment_schedule_id,pend_date) -
258: Get_Adj_Total_GL(ps.payment_schedule_id,pend_date) +
259: nvl(ps.acctd_amount_due_remaining,0))
260: INTO rem_sales
261: FROM ar_payment_schedules_all ps,
262: ra_customer_trx_all trx
263: WHERE ps.gl_date between pstart_date and pend_date
264: AND ps.class in ('INV','DEP','DM','CB')
265: AND ps.customer_trx_id = trx.customer_trx_id