APPS.ARRX_TX dependencies on DUAL

Line 77: FROM dual;

73: var.request_id := request_id;
74:
75: SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),1,10),' '),-99))
76: INTO l_client_info_org_id
77: FROM dual;
78:
79: var.reporting_level := nvl(reporting_level,'3000');
80: var.reporting_entity_id := nvl(reporting_entity_id,l_client_info_org_id);
81: var.start_account := start_account;

Line 103: FROM dual;

99: * Using replace to change spaces to null when RSOB not set
100: */
101: SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),45,10),' '),-99))
102: INTO l_client_info_rsob_id
103: FROM dual;
104:
105: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
106: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
107: (l_client_info_rsob_id = -99)