DBA Data[Home] [Help]

APPS.CE_BANK_PUB dependencies on DUAL

Line 2050: FROM sys.dual;

2046: x_msg_data OUT NOCOPY VARCHAR2
2047: ) IS
2048: CURSOR c_acct_id IS
2049: SELECT CE_BANK_ACCOUNTS_S.nextval
2050: FROM sys.dual;
2051: CURSOR c_acct_rowid IS
2052: SELECT rowid
2053: FROM CE_BANK_ACCOUNTS
2054: WHERE bank_account_id = x_acct_id;

Line 3056: FROM sys.dual;

3052: x_msg_data OUT NOCOPY VARCHAR2
3053: ) IS
3054: CURSOR c_acct_use_id IS
3055: SELECT CE_BANK_ACCT_USES_S.nextval
3056: FROM sys.dual;
3057: CURSOR c_acct_use_rowid IS
3058: SELECT rowid
3059: FROM CE_BANK_ACCT_USES_ALL
3060: WHERE bank_acct_use_id = x_acct_use_id;