APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VWP_STAGES_VL

Line 229: from ahl_vwp_stages_vl s

225: CURSOR C_STAGE(C_VISIT_ID number)
226: is
227: select s.stage_id, s.stage_num, s.stage_name,
228: s.object_version_number, s.duration
229: from ahl_vwp_stages_vl s
230: where s.visit_id = c_visit_id
231: order by s.stage_num;
232: */
233: CURSOR C_STAGE(c_visit_id IN NUMBER)

Line 256: FROM ahl_vwp_stages_vl s

252: ,S.attribute12
253: ,S.attribute13
254: ,S.attribute14
255: ,S.attribute15
256: FROM ahl_vwp_stages_vl s
257: WHERE s.visit_id = c_visit_id
258: ORDER BY s.stage_num;
259:
260: l_stage_rec C_STAGE%rowtype;

Line 906: FROM AHL_VWP_STAGES_VL

902: CURSOR c_sum_stage_duration (c_stage_id NUMBER,
903: c_visit_id NUMBER)
904: IS
905: SELECT sum(duration)
906: FROM AHL_VWP_STAGES_VL
907: WHERE visit_id = c_visit_id
908: AND stage_num < (select stage_num
909: from AHL_VWP_STAGES_VL
910: WHERE stage_id = c_stage_id

Line 909: from AHL_VWP_STAGES_VL

905: SELECT sum(duration)
906: FROM AHL_VWP_STAGES_VL
907: WHERE visit_id = c_visit_id
908: AND stage_num < (select stage_num
909: from AHL_VWP_STAGES_VL
910: WHERE stage_id = c_stage_id
911: AND visit_id = c_visit_id);
912:
913: -- To find visit related information

Line 944: select * from ahl_vwp_stages_vl where stage_id = c_stage_id;

940: l_stages_count NUMBER;
941:
942: cursor C_get_stage_data(c_stage_id number)
943: is
944: select * from ahl_vwp_stages_vl where stage_id = c_stage_id;
945: l_stage_REC C_get_stage_data%rowtype;
946:
947: l_is_planned_end_date_updated BOOLEAN default false;
948:

Line 1378: from AHL_VWP_STAGES_VL

1374:
1375: cursor c_stage_data(c_stage_id number)
1376: IS
1377: select stage_name, duration, object_version_number
1378: from AHL_VWP_STAGES_VL
1379: where stage_id = c_stage_id;
1380:
1381: l_stage_rec c_stage_data%rowtype;
1382:

Line 1835: SELECT 'x' FROM AHL_VWP_STAGES_VL

1831: l_dummy varchar2(1);
1832:
1833: cursor c_stage_name(C_VISIT_ID number, C_STAGE_NAME varchar2, C_STAGE_ID number)
1834: IS
1835: SELECT 'x' FROM AHL_VWP_STAGES_VL
1836: WHERE VISIT_ID = C_VISIT_ID AND
1837: STAGE_ID <> C_STAGE_ID AND
1838: STAGE_NAME = C_STAGE_NAME;
1839:

Line 1843: from AHL_VWP_STAGES_VL

1839:
1840: cursor c_stage_data(c_stage_id number)
1841: IS
1842: select stage_name, duration, object_version_number
1843: from AHL_VWP_STAGES_VL
1844: where stage_id = c_stage_id;
1845:
1846: l_stage_rec c_stage_data%rowtype;
1847:

Line 2112: SELECT stage_id,stage_num FROM ahl_vwp_stages_vl

2108:
2109: --Get stage id for a given task
2110: CURSOR c_get_stage_id(c_stage_name IN VARCHAR2, c_visit_id IN NUMBER)
2111: IS
2112: SELECT stage_id,stage_num FROM ahl_vwp_stages_vl
2113: WHERE stage_name = c_stage_name
2114: AND visit_id = c_visit_id;
2115: -- VWP ER-12424063:: tchimira :: 1-JUN-2011:: end
2116:

Line 2240: select * from ahl_vwp_stages_vl where stage_id = c_stage_id;

2236: )
2237: is
2238: cursor C_get_stage_data(c_stage_id number)
2239: is
2240: select * from ahl_vwp_stages_vl where stage_id = c_stage_id;
2241: l_stage_REC C_get_stage_data%rowtype;
2242:
2243: begin
2244: OPEN C_get_stage_data(p_x_stages_rec.STAGE_ID);

Line 2295: FROM AHL_VWP_STAGES_VL

2291: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
2292: BEGIN
2293: IF (p_Stage_Name IS NOT NULL) THEN
2294: SELECT Stage_Id INTO x_Stage_id
2295: FROM AHL_VWP_STAGES_VL
2296: WHERE Visit_Id = p_visit_id AND Stage_Name = p_Stage_Name;
2297: ELSE
2298: x_Stage_id := null;
2299: END IF;

Line 2901: FROM ahl_vwp_stages_vl

2897:
2898: --To fetch visit id.
2899: CURSOR get_stage_details (p_stage_id IN NUMBER) IS
2900: SELECT visit_id, stage_name
2901: FROM ahl_vwp_stages_vl
2902: WHERE stage_id = p_stage_id;
2903:
2904: --To get visit tasks of a given stage type
2905: -- Here in the cursor, we are adding additional condition that "stage_id should be null";