APPS.ISC_DBI_PLAN_ORGS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

SELECT	0	ISC_ATTRIBUTE_1
  FROM	dual
 WHERE	1 = 2 /* PLAN_SNAPSHOT dimension has not been populated */';

Line: 36

SELECT	org.name	ISC_ATTRIBUTE_1 -- Planned Organizations
  FROM	ISC_DBI_PLAN_ORG_SNAPSHOTS	f,
	HR_ALL_ORGANIZATION_UNITS_TL	org
 WHERE	f.organization_id = org.organization_id
   AND	org.language = :ISC_LANG
   AND	f.snapshot_id IN (&PLAN_SNAPSHOT+PLAN_SNAPSHOT)
&ORDER_BY_CLAUSE NULLS LAST';