APPS.PA_LOCATIONS_PKG dependencies on DUAL

Line 27: FROM sys.dual;

23: if (x_location_id is null ) THEN
24:
25: SELECT pa_locations_s.nextval
26: INTO x_location_id
27: FROM sys.dual;
28:
29: end if;
30:
31: insert into PA_LOCATIONS (

Line 51: from sys.dual

47: p_CREATED_BY,
48: p_LAST_UPDATE_DATE,
49: p_LAST_UPDATED_BY,
50: p_LAST_UPDATE_LOGIN
51: from sys.dual
52: where not exists
53: (select NULL
54: from PA_LOCATIONS L
55: where L.LOCATION_ID = X_LOCATION_ID );