DBA Data[Home] [Help]

APPS.AHL_VWP_COST_PVT dependencies on AHL_VISITS_VL

Line 1501: SELECT * FROM AHL_VISITS_VL

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

Line 2034: SELECT * FROM AHL_VISITS_VL

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