APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VWP_STAGES_VL

Line 135: from ahl_vwp_stages_vl s

131: CURSOR C_STAGE(C_VISIT_ID number)
132: is
133: select s.stage_id, s.stage_num, s.stage_name,
134: s.object_version_number, s.duration
135: from ahl_vwp_stages_vl s
136: where s.visit_id = c_visit_id
137: order by s.stage_num;
138:
139: l_stage_rec C_STAGE%rowtype;

Line 1030: SELECT 'x' FROM AHL_VWP_STAGES_VL

1026: l_dummy varchar2(1);
1027:
1028: cursor c_stage_name(C_VISIT_ID number, C_STAGE_NAME varchar2, C_STAGE_ID number)
1029: IS
1030: SELECT 'x' FROM AHL_VWP_STAGES_VL
1031: WHERE VISIT_ID = C_VISIT_ID AND
1032: STAGE_ID <> C_STAGE_ID AND
1033: STAGE_NAME = C_STAGE_NAME;
1034:

Line 1038: from AHL_VWP_STAGES_VL

1034:
1035: cursor c_stage_data(c_stage_id number)
1036: IS
1037: select stage_name, duration, object_version_number
1038: from AHL_VWP_STAGES_VL
1039: where stage_id = c_stage_id;
1040:
1041: l_stage_rec c_stage_data%rowtype;
1042:

Line 1286: SELECT STAGE_NUM, stage_id FROM AHL_VWP_STAGES_VL

1282:
1283:
1284: CURSOR C_STAGE_NUM(P_VISIT_ID NUMBER, P_STAGE_NAME VARCHAR2)
1285: is
1286: SELECT STAGE_NUM, stage_id FROM AHL_VWP_STAGES_VL
1287: WHERE STAGE_NAME = P_STAGE_NAME AND VISIT_ID = P_VISIT_ID;
1288:
1289: begin
1290:

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

1360: )
1361: is
1362: cursor C_get_stage_data(c_stage_id number)
1363: is
1364: select * from ahl_vwp_stages_vl where stage_id = c_stage_id;
1365: l_stage_REC C_get_stage_data%rowtype;
1366:
1367: begin
1368: OPEN C_get_stage_data(p_x_stages_rec.STAGE_ID);

Line 1411: FROM AHL_VWP_STAGES_VL

1407: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
1408: BEGIN
1409: IF (p_Stage_Name IS NOT NULL) THEN
1410: SELECT Stage_Id INTO x_Stage_id
1411: FROM AHL_VWP_STAGES_VL
1412: WHERE Visit_Id = p_visit_id AND Stage_Name = p_Stage_Name;
1413: ELSE
1414: x_Stage_id := null;
1415: END IF;