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 1814: INTO l_sy_date FROM SYS.DUAL ;

1810: END IF;
1811:
1812: BEGIN
1813: SELECT to_date((FND_PROFILE.VALUE('SY$MAX_DATE')),'YYYY/MM/DD')
1814: INTO l_sy_date FROM SYS.DUAL ;
1815: x_return_status := 'S';
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: x_return_status := 'E';