DBA Data[Home] [Help]

APPS.CE_PAYMENT_TRXN_PKG dependencies on DUAL

Line 85: CURSOR C1 IS SELECT CE_PAYMENT_TRANSACTIONS_S.NEXTVAL FROM DUAL;

81: ) IS
82:
83: CURSOR C IS SELECT ROWID FROM CE_PAYMENT_TRANSACTIONS
84: WHERE TRXN_REFERENCE_NUMBER = X_TRXN_REFERENCE_NUMBER;
85: CURSOR C1 IS SELECT CE_PAYMENT_TRANSACTIONS_S.NEXTVAL FROM DUAL;
86:
87: BEGIN
88: IF ( X_TRXN_REFERENCE_NUMBER ) IS NULL THEN
89: OPEN C1;