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: -- Bug 9346163
126: -- Rewrote the cursor to pick nextval(s) from the sequence.
127: -- The old cursor would not return values in case the table in the FROM

Line 130: -- Dual with Connect by would give the same result and is safe.

126: -- Rewrote the cursor to pick nextval(s) from the sequence.
127: -- The old cursor would not return values in case the table in the FROM
128: -- clause is empty. While it is a bad idea to use a physical table
129: -- in such a case, using a transactional table is asking for trouble.
130: -- Dual with Connect by would give the same result and is safe.
131:
132: /*
133: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
134: IS

Line 144: FROM SYS.DUAL

140:
141: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
142: IS
143: SELECT hxc_transaction_details_s.NEXTVAL
144: FROM SYS.DUAL
145: CONNECT BY LEVEL <= p_max ;
146:
147: g_conc_request_id NUMBER (15);
148:

Line 1212: FROM DUAL;

1208: IS
1209: CURSOR csr_get_rr_id
1210: IS
1211: SELECT hxc_retrieval_ranges_s.NEXTVAL
1212: FROM DUAL;
1213:
1214: l_rr_id NUMBER (15);
1215: l_proc VARCHAR2 (72);
1216: BEGIN

Line 8064: FROM DUAL;

8060:
8061: BEGIN
8062: SELECT TO_NUMBER (l_since_date)
8063: INTO l_since_date
8064: FROM DUAL;
8065: EXCEPTION
8066: WHEN OTHERS
8067: THEN
8068: l_since_date := 60;