DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_SPACE_ASSIGNMENTS_S

Line 765: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL

761: l_space_assign_rec Space_Assignment_Rec;
762: --
763: CURSOR c_seq
764: IS
765: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL
766: FROM dual;
767: --
768: CURSOR c_id_exists (x_id IN NUMBER) IS
769: SELECT 1

Line 1472: FROM ahl_space_assignments sa,

1468: vt.organization_id,
1469: vt.department_id,
1470: sp.organization_id sporg_id,
1471: sp.bom_department_id spdept_id
1472: FROM ahl_space_assignments sa,
1473: ahl_visits_vl vt,
1474: ahl_spaces_b sp
1475: WHERE sa.visit_id = vt.visit_id
1476: AND sp.space_id = sa.space_id