APPS.AHL_FMP_COMMON_PVT dependencies on DUAL

Line 1223: FROM DUAL

1219:
1220: CURSOR compare_numbers ( c_serial_number_from VARCHAR2 , c_serial_number_to VARCHAR2 )
1221: IS
1222: SELECT 'X'
1223: FROM DUAL
1224: WHERE TO_NUMBER( c_serial_number_to ) >=
1225: TO_NUMBER( c_serial_number_from );
1226:
1227: CURSOR compare_chars ( c_serial_number_from VARCHAR2 , c_serial_number_to VARCHAR2 )

Line 1230: FROM DUAL

1226:
1227: CURSOR compare_chars ( c_serial_number_from VARCHAR2 , c_serial_number_to VARCHAR2 )
1228: IS
1229: SELECT 'X'
1230: FROM DUAL
1231: WHERE c_serial_number_to >= c_serial_number_from;
1232:
1233: BEGIN
1234: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1822: FROM DUAL

1818:
1819: CURSOR mr_type_program( c_effectivity_id NUMBER,c_eff_obj number,c_mr_header_id number)
1820: IS
1821: SELECT 1
1822: FROM DUAL
1823: WHERE
1824: EXISTS (
1825: SELECT 'x'
1826: FROM AHL_UNIT_EFFECTIVITIES_B unit,

Line 1874: FROM DUAL

1870:
1871: CURSOR mr_type_activity( c_effectivity_id NUMBER,c_eff_obj number)
1872: IS
1873: SELECT 1
1874: FROM DUAL
1875: WHERE EXISTS ( SELECT 'x'
1876: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1877: CSI_ITEM_INSTANCES csi,
1878: AHL_MR_EFFECTIVITIES eff