DBA Data[Home] [Help]

APPS.OPI_DBI_SCRAP_JOB_DTL_PKG dependencies on DUAL

Line 133: FROM dual;

129: IF (upper(l_org)<>'ALL') THEN
130: --{
131: SELECT trim(both '''' from l_org)
132: INTO l_org
133: FROM dual;
134: --}
135: END IF;
136:
137: IF (l_org is NULL) THEN

Line 139: SELECT fnd_global.resp_id INTO l_respid from dual ;

135: END IF;
136:
137: IF (l_org is NULL) THEN
138: --{
139: SELECT fnd_global.resp_id INTO l_respid from dual ;
140:
141: SELECT id INTO l_org
142: FROM (SELECT id
143: FROM bis_organizations_v

Line 317: FROM dual WHERE 1=2';

313: ,NULL OPI_MEASURE7
314: ,NULL OPI_MEASURE8
315: ,NULL OPI_MEASURE9
316: ,NULL OPI_MEASURE10
317: FROM dual WHERE 1=2';
318: --}
319: END IF;
320:
321: