APPS.AHL_LTP_SPACE_CAPB_PVT dependencies on DUAL

Line 799: FROM dual;

795: --
796: CURSOR c_seq
797: IS
798: SELECT AHL_SPACES_B_S.NEXTVAL
799: FROM dual;
800: --
801: CURSOR c_id_exists (x_id IN NUMBER) IS
802: SELECT 1
803: FROM dual

Line 803: FROM dual

799: FROM dual;
800: --
801: CURSOR c_id_exists (x_id IN NUMBER) IS
802: SELECT 1
803: FROM dual
804: WHERE EXISTS (SELECT 1
805: FROM ahl_spaces_b
806: WHERE space_id = x_id);
807: --

Line 2322: FROM dual;

2318: --
2319: CURSOR c_seq
2320: IS
2321: SELECT AHL_SPACE_CAPABILITIES_S.NEXTVAL
2322: FROM dual;
2323: --
2324: CURSOR c_id_exists (x_id IN NUMBER) IS
2325: SELECT 1
2326: FROM dual

Line 2326: FROM dual

2322: FROM dual;
2323: --
2324: CURSOR c_id_exists (x_id IN NUMBER) IS
2325: SELECT 1
2326: FROM dual
2327: WHERE EXISTS (SELECT 1
2328: FROM ahl_space_capabilities
2329: WHERE space_capability_id = x_id);
2330: --Get organization id