DBA Data[Home] [Help]

APPS.AR_CMGT_ACCOUNT_MERGE dependencies on FND_GLOBAL

Line 802: FND_GLOBAL.user_id,

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)

Line 803: FND_GLOBAL.login_id

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)

Line 1434: FND_GLOBAL.user_id,

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)

Line 1435: FND_GLOBAL.login_id

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)