APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISITS_B_S

Line 545: SELECT Ahl_Visits_B_S.NEXTVAL

541: FUNCTION Get_Visit_Id RETURN NUMBER IS
542:
543: -- To find the next id value from visit sequence
544: CURSOR c_seq IS
545: SELECT Ahl_Visits_B_S.NEXTVAL
546: FROM dual;
547:
548: -- To find whether id already exists
549: CURSOR c_id_exists (x_id IN NUMBER) IS

Line 1692: SELECT Ahl_Visits_B_S.NEXTVAL

1688:
1689: -- Define local Cursors
1690: -- To find the next id value from visit sequence
1691: CURSOR c_seq IS
1692: SELECT Ahl_Visits_B_S.NEXTVAL
1693: FROM dual;
1694:
1695: -- To find whether id already exists
1696: CURSOR c_id_exists (x_id IN NUMBER) IS