APPS.ARRX_RC dependencies on DUAL

Line 1502: from dual;

1498:
1499: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1500: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1501: into l_client_info_rsob_id
1502: from dual;
1503:
1504: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1505: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1506: (l_client_info_rsob_id = -99)

Line 1627: into l_client_info_rsob_id from dual;

1623:
1624: end if;
1625: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1626: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1627: into l_client_info_rsob_id from dual;
1628: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1629: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1630: (l_client_info_rsob_id = -99)
1631: THEN

Line 1763: FROM dual;

1759: var.request_id := request_id;
1760:
1761: SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),45,10),' '),-99))
1762: INTO l_client_info_rsob_id
1763: FROM dual;
1764:
1765: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1766: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1767: (l_client_info_rsob_id = -99)