APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISITS_B

Line 258: FROM ahl_visits_b

254: -- Cursor to get organization and schedule designator
255: CURSOR get_org_cur (c_visit_id IN NUMBER)
256: IS
257: SELECT organization_id
258: FROM ahl_visits_b
259: WHERE visit_id = c_visit_id;
260: --Get priority item from item associations
261: CURSOR Get_Prior_Item_Cur(C_ITEM_GROUP_ID IN NUMBER,
262: C_ORG_ID IN NUMBER)

Line 781: FROM ahl_visits_b

777: -- Serial Number Resrvation Change Starts
778: CURSOR Get_Visit_Dates_cur (c_visit_id IN NUMBER)
779: IS
780: SELECT start_date_time, close_date_time
781: FROM ahl_visits_b
782: WHERE visit_id = c_visit_id;
783:
784: -- Serial Number Resrvation Change ends
785:

Line 1148: FROM ahl_visits_b vs,

1144: vt.visit_task_id,
1145: vt.mr_route_id,
1146: vt.instance_id,
1147: vt.start_date_time
1148: FROM ahl_visits_b vs,
1149: ahl_visit_tasks_b vt
1150: WHERE vs.visit_id = vt.visit_id
1151: AND vt.visit_task_id = C_VISIT_TASK_ID;
1152:

Line 1550: FROM ahl_visits_b

1546: l_visit_org_id NUMBER;
1547: CURSOR Get_Visit_Org_Id_Cur(c_visit_id IN NUMBER)
1548: IS
1549: SELECT organization_id
1550: FROM ahl_visits_b
1551: WHERE visit_id = C_VISIT_ID
1552: AND ( organization_id IS NOT NULL
1553: OR start_date_time IS NOT NULL
1554: OR department_id IS NOT NULL

Line 2196: FROM ahl_visits_b

2192: --priyan begin
2193: CURSOR get_assoc_primary_id (c_visit_id IN NUMBER)
2194: IS
2195: SELECT asso_primary_visit_id
2196: FROM ahl_visits_b
2197: WHERE visit_id = c_visit_id;
2198: --priyan end
2199: BEGIN
2200:

Line 3049: FROM ahl_visits_b

3045: AND RSV.inventory_item_id = mat.inventory_item_id );
3046:
3047: CURSOR get_cur_org_csr(p_visit_id IN NUMBER) IS
3048: SELECT organization_id
3049: FROM ahl_visits_b
3050: WHERE visit_id = p_visit_id;
3051:
3052: CURSOR get_prev_org_csr(p_visit_id IN NUMBER) IS
3053: SELECT organization_id