APPS.INV_GENEALOGY_PUB dependencies on DUAL

Line 157: FROM DUAL

153: IF end_date IS NULL THEN
154: BEGIN
155: SELECT 1
156: INTO l_dummy
157: FROM DUAL
158: WHERE parent_object_id IN (SELECT mog.object_id
159: FROM mtl_object_genealogy mog
160: WHERE (end_date_active IS NULL OR end_date_active >= start_date)
161: AND parent_object_id = l_object_id

Line 171: FROM DUAL

167: ELSE
168: BEGIN
169: SELECT 1
170: INTO l_dummy
171: FROM DUAL
172: WHERE parent_object_id IN (SELECT mog.object_id
173: FROM mtl_object_genealogy mog
174: WHERE (((start_date_active <= start_date)
175: AND (end_date_active IS NULL

Line 227: FROM DUAL;

223: , object_id_rec.end_date_active
224: INTO object_table(l_count).object_id
225: , object_table(l_count).start_date_active
226: , object_table(l_count).end_date_active
227: FROM DUAL;
228:
229: IF (object_id_rec.start_date_active > end_date)
230: OR (object_id_rec.end_date_active < start_date) THEN
231: NULL;

Line 289: FROM DUAL;

285: , object_id_rec.end_date_active
286: INTO object_table(l_count + 1).object_id
287: , object_table(l_count + 1).start_date_active
288: , object_table(l_count + 1).end_date_active
289: FROM DUAL;
290:
291: IF (object_id_rec.start_date_active > end_date)
292: OR (object_id_rec.end_date_active < start_date) THEN
293: NULL;

Line 807: FROM DUAL;

803: l_parent_serial_number VARCHAR2(30);
804: BEGIN
805: SELECT l_object_id
806: INTO l_object_table(1).object_id
807: FROM DUAL;
808:
809: -- call to the function that checks for the genealogy loop
810: retval := genealogy_loop(l_object_id, l_parent_object_id,
811: p_start_date_active, p_end_date_active, l_object_table);

Line 1294: FROM DUAL

1290:
1291: BEGIN
1292: SELECT 'Y'
1293: INTO l_dummy_char
1294: FROM DUAL
1295: WHERE EXISTS( SELECT *
1296: FROM mtl_object_genealogy
1297: WHERE genealogy_type = 5
1298: AND object_id = l_object_id