APPS.AHL_FMP_COMMON_PVT dependencies on DUAL

Line 1234: FROM DUAL

1230:
1231: CURSOR compare_numbers ( c_serial_number_from VARCHAR2 , c_serial_number_to VARCHAR2 )
1232: IS
1233: SELECT 'X'
1234: FROM DUAL
1235: WHERE TO_NUMBER( c_serial_number_to ) >=
1236: TO_NUMBER( c_serial_number_from );
1237:
1238: CURSOR compare_chars ( c_serial_number_from VARCHAR2 , c_serial_number_to VARCHAR2 )

Line 1241: FROM DUAL

1237:
1238: CURSOR compare_chars ( c_serial_number_from VARCHAR2 , c_serial_number_to VARCHAR2 )
1239: IS
1240: SELECT 'X'
1241: FROM DUAL
1242: WHERE c_serial_number_to >= c_serial_number_from;
1243:
1244: BEGIN
1245: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1881: FROM DUAL

1877:
1878: CURSOR mr_type_program( c_effectivity_id NUMBER,c_eff_obj number,c_mr_header_id number)
1879: IS
1880: SELECT 1
1881: FROM DUAL
1882: WHERE
1883: EXISTS (
1884: SELECT 'x'
1885: FROM AHL_UNIT_EFFECTIVITIES_B unit,

Line 1933: FROM DUAL

1929:
1930: CURSOR mr_type_activity( c_effectivity_id NUMBER,c_eff_obj number)
1931: IS
1932: SELECT 1
1933: FROM DUAL
1934: WHERE EXISTS ( SELECT 'x'
1935: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1936: CSI_ITEM_INSTANCES csi,
1937: AHL_MR_EFFECTIVITIES eff