APPS.AHL_LTP_SPACE_CAPB_PVT dependencies on AHL_SPACES_B

Line 798: SELECT AHL_SPACES_B_S.NEXTVAL

794: l_space_rec Space_Rec;
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

Line 805: FROM ahl_spaces_b

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: --
808: BEGIN
809: --------------------Initialize ----------------------------------

Line 1649: UPDATE AHL_SPACES_B

1645: FND_MESSAGE.set_name('AHL', 'AHL_LTP_SP_VISITS_ASSIGNED');
1646: FND_MSG_PUB.add;
1647: RAISE Fnd_Api.G_EXC_ERROR;
1648: ELSE
1649: UPDATE AHL_SPACES_B
1650: SET INACTIVE_FLAG = 'N'
1651: WHERE space_id = l_space_id;
1652: END IF;
1653: END IF;

Line 2334: FROM AHL_SPACES_B

2330: --Get organization id
2331: CURSOR get_org_cur (c_space_id IN NUMBER)
2332: IS
2333: SELECT organization_id
2334: FROM AHL_SPACES_B
2335: WHERE SPACE_ID = c_space_id;
2336:
2337: BEGIN
2338:

Line 2873: FROM AHL_SPACES_B

2869: --Get organization id
2870: CURSOR get_org_cur (c_space_id IN NUMBER)
2871: IS
2872: SELECT organization_id
2873: FROM AHL_SPACES_B
2874: WHERE SPACE_ID = c_space_id;
2875:
2876: BEGIN
2877: