DBA Data[Home] [Help]

APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISITS_VL

Line 309: SELECT * FROM AHL_VISITS_VL

305: l_msg_count NUMBER;
306:
307: -- To find visit related information
308: CURSOR c_visit(x_id IN NUMBER) IS
309: SELECT * FROM AHL_VISITS_VL
310: WHERE VISIT_ID = x_id;
311: c_visit_rec c_visit%ROWTYPE;
312:
313: BEGIN

Line 551: FROM Ahl_Visits_VL

547:
548: -- To find visit related information
549: CURSOR c_Visit (p_visit_id IN NUMBER) IS
550: SELECT Any_Task_Chg_Flag, Visit_Id
551: FROM Ahl_Visits_VL
552: WHERE VISIT_ID = p_visit_id;
553: l_visit_csr_rec c_Visit%ROWTYPE;
554:
555: -- To find if this Unit has been planned in other visits already

Line 1455: SELECT * FROM Ahl_Visits_VL

1451: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
1452:
1453: -- To find visit related information
1454: CURSOR c_Visit (x_id IN NUMBER) IS
1455: SELECT * FROM Ahl_Visits_VL
1456: WHERE VISIT_ID = x_id;
1457: c_Visit_rec c_Visit%ROWTYPE;
1458:
1459: -- To find task related information