798: nvl(yt1.LAST_PAYMENT_DATE, yt.last_payment_date)),
799: yt.LAST_PAYMENT_DATE, yt.LAST_PAYMENT_NUMBER,
800: yt1.LAST_PAYMENT_NUMBER),
801: sysdate,
802: FND_GLOBAL.user_id,
803: FND_GLOBAL.login_id
804: FROM ar_trx_bal_summary yt1
805: WHERE yt1.cust_account_id = PRIMARY_KEY1_LIST(I)
806: AND yt1.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
799: yt.LAST_PAYMENT_DATE, yt.LAST_PAYMENT_NUMBER,
800: yt1.LAST_PAYMENT_NUMBER),
801: sysdate,
802: FND_GLOBAL.user_id,
803: FND_GLOBAL.login_id
804: FROM ar_trx_bal_summary yt1
805: WHERE yt1.cust_account_id = PRIMARY_KEY1_LIST(I)
806: AND yt1.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
807: AND yt1.CURRENCY=PRIMARY_KEY3_LIST(I)
1430: nvl(yt1.NSF_STOP_PAYMENT_AMOUNT,0)),
1431: nvl(yt.NSF_STOP_PAYMENT_AMOUNT,0) +
1432: nvl(yt1.NSF_STOP_PAYMENT_AMOUNT,0)),
1433: sysdate,
1434: FND_GLOBAL.user_id,
1435: FND_GLOBAL.login_id
1436: FROM ar_trx_summary yt1
1437: WHERE yt1.cust_account_id = PRIMARY_KEY1_LIST(I)
1438: AND yt1.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
1431: nvl(yt.NSF_STOP_PAYMENT_AMOUNT,0) +
1432: nvl(yt1.NSF_STOP_PAYMENT_AMOUNT,0)),
1433: sysdate,
1434: FND_GLOBAL.user_id,
1435: FND_GLOBAL.login_id
1436: FROM ar_trx_summary yt1
1437: WHERE yt1.cust_account_id = PRIMARY_KEY1_LIST(I)
1438: AND yt1.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
1439: AND yt1.CURRENCY=PRIMARY_KEY3_LIST(I)