DBA Data[Home] [Help]

APPS.AR_LOCVS_PKG dependencies on DUAL

Line 100: from dual;

96: | Sequence ID + large constant used for debugging |
97: +-------------------------------------------------------------------------*/
98: CURSOR ar_location_accounts_s_c IS
99: select ar_location_accounts_s.nextval + arp_standard.sequence_offset
100: from dual;
101:
102: /*------------------------------------------------------------------------+
103: | PRIVATE CURSOR |
104: | organization_id_c |

Line 255: from dual;

251: Commented out as X_ORG_ID is passed from UI as part of the parameter.
252: select NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV ('CLIENT_INFO'),1,1), ' ',NULL,
253: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
254: into X_ORG_ID
255: from dual;
256: */
257:
258: /* +----------------------------------------------------------------------------------
259: Insert in AR_LOCATION_ACCOUNTS only if the TAX_ACCOUNT_CCID is not null