APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISITS_B

Line 318: FROM ahl_visits_b

314: -- Cursor to get organization and schedule designator
315: CURSOR get_org_cur (c_visit_id IN NUMBER)
316: IS
317: SELECT organization_id
318: FROM ahl_visits_b
319: WHERE visit_id = c_visit_id;
320: --Get priority item from item associations
321: CURSOR Get_Prior_Item_Cur(C_ITEM_GROUP_ID IN NUMBER,
322: C_ORG_ID IN NUMBER)

Line 792: FROM ahl_visits_b

788: -- Serial Number Resrvation Change Starts
789: CURSOR Get_Visit_Dates_cur (c_visit_id IN NUMBER)
790: IS
791: SELECT start_date_time, close_date_time
792: FROM ahl_visits_b
793: WHERE visit_id = c_visit_id;
794:
795: -- Serial Number Resrvation Change ends
796:

Line 1159: FROM ahl_visits_b vs,

1155: vt.visit_task_id,
1156: vt.mr_route_id,
1157: vt.instance_id,
1158: vt.start_date_time
1159: FROM ahl_visits_b vs,
1160: ahl_visit_tasks_b vt
1161: WHERE vs.visit_id = vt.visit_id
1162: AND vt.visit_task_id = C_VISIT_TASK_ID;
1163:

Line 1602: FROM ahl_visits_b

1598: -- when a task was being deleted.
1599: l_visit_org_id NUMBER;
1600: CURSOR Get_Visit_Org_Id_Cur(c_visit_id IN NUMBER)IS
1601: SELECT organization_id
1602: FROM ahl_visits_b
1603: WHERE visit_id = C_VISIT_ID
1604: AND ( organization_id IS NOT NULL
1605: OR start_date_time IS NOT NULL
1606: OR department_id IS NOT NULL);

Line 2346: FROM ahl_visits_b

2342: --priyan begin
2343: CURSOR get_assoc_primary_id (c_visit_id IN NUMBER)
2344: IS
2345: SELECT asso_primary_visit_id
2346: FROM ahl_visits_b
2347: WHERE visit_id = c_visit_id;
2348: --priyan end
2349: BEGIN
2350:

Line 3118: FROM ahl_visits_b

3114: AND RSV.inventory_item_id = mat.inventory_item_id );
3115:
3116: CURSOR get_cur_org_csr(p_visit_id IN NUMBER) IS
3117: SELECT organization_id
3118: FROM ahl_visits_b
3119: WHERE visit_id = p_visit_id;
3120:
3121: CURSOR get_prev_org_csr(p_visit_id IN NUMBER) IS
3122: SELECT organization_id

Line 3548: FROM ahl_visits_b

3544:
3545: Cursor get_visit_org_id (c_visit_id IN NUMBER)
3546: IS
3547: SELECT organization_id
3548: FROM ahl_visits_b
3549: WHERE visit_id = c_visit_id;
3550: l_visit_org_id NUMBER;
3551:
3552: Cursor get_scheduled_mat_detls (c_task_id IN NUMBER, c_item_id IN NUMBER)

Line 4021: FROM ahl_visits_b

4017:
4018: Cursor get_visit_org_id (c_visit_id IN NUMBER)
4019: IS
4020: SELECT organization_id
4021: FROM ahl_visits_b
4022: WHERE visit_id = c_visit_id;
4023: l_visit_org_id get_visit_org_id%ROWTYPE;
4024:
4025: Cursor get_scheduled_mat_detls (c_task_id IN NUMBER, c_item_id IN NUMBER)