APPS.ARRX_RC dependencies on DUAL

Line 1575: from dual;

1571:
1572: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1573: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1574: into l_client_info_rsob_id
1575: from dual;
1576:
1577: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1578: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1579: (l_client_info_rsob_id = -99)

Line 1700: into l_client_info_rsob_id from dual;

1696:
1697: end if;
1698: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1699: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1700: into l_client_info_rsob_id from dual;
1701: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1702: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1703: (l_client_info_rsob_id = -99)
1704: THEN

Line 1836: FROM dual;

1832: var.request_id := request_id;
1833:
1834: SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),45,10),' '),-99))
1835: INTO l_client_info_rsob_id
1836: FROM dual;
1837:
1838: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1839: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1840: (l_client_info_rsob_id = -99)