APPS.GMP_RESOURCE_DTL_PUB dependencies on DUAL

Line 51: FROM sys.dual;

47: invalid_version EXCEPTION;
48:
49: CURSOR Cur_resource_id IS
50: SELECT BOM_RESOURCES_S.nextval
51: FROM sys.dual;
52:
53: CURSOR Cur_instance_id IS
54: SELECT GMP_RESOURCE_INSTANCES_S.nextval
55: FROM sys.DUAL;

Line 55: FROM sys.DUAL;

51: FROM sys.dual;
52:
53: CURSOR Cur_instance_id IS
54: SELECT GMP_RESOURCE_INSTANCES_S.nextval
55: FROM sys.DUAL;
56:
57: /* B4724360 Rajesh Patangya INVCONV */
58: CURSOR Cur_uom IS
59: SELECT STD_USAGE_UOM,CAPACITY_UM,MIN_CAPACITY,MAX_CAPACITY

Line 1841: INTO l_sy_date FROM SYS.DUAL ;

1837: END IF;
1838:
1839: BEGIN
1840: SELECT to_date((FND_PROFILE.VALUE('SY$MAX_DATE')),'YYYY/MM/DD')
1841: INTO l_sy_date FROM SYS.DUAL ;
1842: x_return_status := 'S';
1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: x_return_status := 'E';