1143: ara.applied_payment_schedule_id,
1144: acr.receipt_number,
1145: acr.cash_receipt_id,
1146: acr.amount
1147: from ar_receivable_applications_all ara,
1148: ar_cash_receipts_all acr,
1149: --ra_customers rc, ----Bug#4476059 Quick Change
1150: hz_cust_accounts hzca1,
1151: hz_parties hzp1,
1182: ara.applied_payment_schedule_id,
1183: acr.receipt_number,
1184: ara.cash_receipt_id,
1185: aps.class
1186: from ar_receivable_applications_all ara,
1187: ar_cash_receipts_all acr,
1188: ar_payment_schedules_all aps
1189: where ara.cash_receipt_id = acr.cash_receipt_id
1190: and acr.set_of_books_id = vp_sob_id
1255: l_cust_trx_id NUMBER;
1256: l_rec_desc_tbl g_rec_desc_type ;
1257:
1258: l_pay_schedule_id ar_payment_schedules_all.payment_schedule_id%type;
1259: schedule_id ar_receivable_applications_all.applied_payment_schedule_id%type;
1260:
1261: dummy varchar2(2);
1262: fc_flag varchar2(2);
1263: l_status ra_customer_trx_all.status_trx%type ;
1338: and apply_date < vl_fy_begin_date + 1;
1339:
1340: select nvl(sum(amount_applied),0) * -1
1341: into l_appld_amount
1342: from ar_receivable_applications_all
1343: where applied_customer_trx_id = recs.customer_trx_id
1344: and apply_date < vl_fy_begin_date + 1;
1345:
1346: amt_fy_begin_bal := amt_fy_begin_bal +
1554: recs.customer_trx_id)
1555: LOOP
1556: select min(applied_payment_schedule_id)
1557: into schedule_id
1558: FROM ar_receivable_applications_all
1559: where applied_customer_trx_id =IIC_col_recs.applied_customer_trx_id
1560: and cash_receipt_id = IIC_col_recs.cash_receipt_id;
1561:
1562: IF(IIC_Col_recs.applied_payment_schedule_id = schedule_id