APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on DUAL

Line 123: FROM SYS.DUAL;

119: -- package cursor
120: CURSOR csr_get_tx_id
121: IS
122: SELECT hxc_transactions_s.NEXTVAL
123: FROM SYS.DUAL;
124:
125: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
126: IS
127: SELECT /*+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) */

Line 799: FROM DUAL;

795: IS
796: CURSOR csr_get_rr_id
797: IS
798: SELECT hxc_retrieval_ranges_s.NEXTVAL
799: FROM DUAL;
800:
801: l_rr_id NUMBER (15);
802: l_proc VARCHAR2 (72);
803: BEGIN

Line 7133: FROM DUAL;

7129:
7130: BEGIN
7131: SELECT TO_NUMBER (l_since_date)
7132: INTO l_since_date
7133: FROM DUAL;
7134: EXCEPTION
7135: WHEN OTHERS
7136: THEN
7137: l_since_date := 60;