DBA Data[Home] [Help]

APPS.AHL_VWP_COST_PVT dependencies on AHL_VISITS_VL

Line 1498: SELECT * FROM AHL_VISITS_VL

1494:
1495: -- Define Local Cursors
1496: -- To find all visit related details
1497: CURSOR c_visit_details (x_id IN NUMBER) IS
1498: SELECT * FROM AHL_VISITS_VL
1499: WHERE VISIT_ID = x_id;
1500: visit_rec c_visit_details%ROWTYPE;
1501:
1502: -- To find visit id for a given task

Line 2031: SELECT * FROM AHL_VISITS_VL

2027:
2028: -- Define Local Cursors
2029: -- To find out all visit related details
2030: CURSOR c_visit_details (x_id IN NUMBER) IS
2031: SELECT * FROM AHL_VISITS_VL
2032: WHERE VISIT_ID = x_id;
2033: visit_rec c_visit_details%ROWTYPE;
2034:
2035: -- yazhou 22Sept2005 starts