APPS.ARP_COLL_IND dependencies on AR_PAYMENT_SCHEDULES

Line 147: FROM ar_payment_schedules ps

143: curr_rec.base_precision,
144: curr_rec.base_min_acc_unit) +
145: Get_Adj_For_Tot_Rec(ps.payment_schedule_id,pend_date))
146: INTO tot_rec
147: FROM ar_payment_schedules ps
148: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
149: AND ps.payment_schedule_id <> -1
150: AND ps.gl_date BETWEEN temp_start AND pend_date
151: AND (pcust_id = -1 OR

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 246: FROM ar_payment_schedules ps

242: SELECT sum(Get_Apps_Total(ps.payment_schedule_id,pend_date) -
243: Get_Adj_Total(ps.payment_schedule_id,pend_date) +
244: nvl(ps.acctd_amount_due_remaining,0))
245: INTO rem_sales
246: FROM ar_payment_schedules ps
247: WHERE ps.gl_date between pstart_date and pend_date
248: AND ps.class in ('INV','DEP','DM','CB')
249: AND ps.gl_date_closed > pend_date
250: AND (pcust_id = -1 OR

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

Line 861: FROM ar_payment_schedules ps

857: Get_Adj_Total(ps.payment_schedule_id,pas_of_date) +
858: nvl(ps.acctd_amount_due_remaining,0)
859: )
860: INTO wtd_days
861: FROM ar_payment_schedules ps
862: WHERE ps.gl_date between pstart_date and pas_of_date
863: AND ps.class in ('INV','DEP','DM','CB')
864: AND ps.gl_date_closed > pas_of_date
865: AND ps.due_date < pas_of_date

Line 926: FROM ar_payment_schedules ps

922: sum(
923: pas_of_date-ps.due_date
924: )
925: INTO wtd_bal
926: FROM ar_payment_schedules ps
927: WHERE ps.gl_date between pstart_date and pas_of_date
928: AND ps.class in ('INV','DEP','DM','CB')
929: AND ps.gl_date_closed > pas_of_date
930: AND ps.due_date < pas_of_date

Line 1000: FROM ar_payment_schedules ps

996: curr_rec.base_min_acc_unit
997: ) +
998: Get_Adj_For_Tot_Rec(ps.payment_schedule_id,pas_of_date)
999: ) v_above_amount
1000: FROM ar_payment_schedules ps
1001: WHERE ps.gl_date BETWEEN pstart_date AND pas_of_date
1002: AND ps.payment_schedule_id <> -1
1003: AND ps.class IN ('INV', 'DM', 'CB', 'DEP' )
1004: AND (pcust_id = -1 OR

Line 1080: ar_payment_schedules ps

1076: FROM (
1077: SELECT
1078: 1 trx
1079: FROM
1080: ar_payment_schedules ps
1081: WHERE
1082: ps.gl_date BETWEEN pstart_date AND pas_of_date
1083: and ps.class IN ('INV', 'DM', 'CB', 'DEP' )
1084: and ps.payment_schedule_id <> -1

Line 1166: ar_payment_schedules ps

1162: ) +
1163: Get_Adj_For_Tot_Rec(ps.payment_schedule_id,pas_of_date)
1164: ) v_below_amount
1165: FROM
1166: ar_payment_schedules ps
1167: WHERE
1168: ps.gl_date BETWEEN pstart_date AND pas_of_date
1169: AND ps.class in ('INV', 'DM', 'CB', 'DEP' )
1170: AND ps.payment_schedule_id <> -1

Line 1244: ar_payment_schedules ps

1240: FROM (
1241: SELECT
1242: 1 trx
1243: FROM
1244: ar_payment_schedules ps
1245: WHERE
1246: ps.gl_date BETWEEN pstart_date AND pas_of_date
1247: and ps.class IN ('INV', 'DM', 'CB', 'DEP' )
1248: and ps.payment_schedule_id <> -1