APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VWP_VISITS_PVT

Line 529: SELECT START_DATE_TIME , department_id, visit_type_code, AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT

525: WHERE stage_id = x_id;
526:
527: -- To find whether id already exists
528: CURSOR c_visit (vst_id IN NUMBER) IS
529: SELECT START_DATE_TIME , department_id, visit_type_code, AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT
530: FROM AHL_VISITS_VL
531: WHERE VISIT_ID = vst_id;
532:
533: l_visit_dets c_visit%RowType;

Line 916: SELECT START_DATE_TIME , department_id, AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT

912:
913: -- To find visit related information
914: CURSOR c_visit (c_visit_id IN NUMBER)
915: IS
916: SELECT START_DATE_TIME , department_id, AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT
917: FROM AHL_VISITS_B
918: WHERE VISIT_ID = c_visit_id;--VWPE 12730539:: PRAKKUM :: 08-JUL-2011
919:
920: l_visit_dets c_visit%RowType;

Line 1386: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT

1382:
1383: -- To find visit related information
1384: CURSOR c_visit (c_visit_id IN NUMBER)
1385: IS
1386: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT
1387: FROM AHL_VISITS_B
1388: WHERE VISIT_ID = c_visit_id;
1389:
1390: l_visit_dets c_visit%RowType;

Line 4674: select DEPARTMENT_ID,START_DATE_TIME,STATUS_CODE,VISIT_TYPE_CODE,AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT

4670:
4671: --cursor to fetch visit details
4672: cursor c_visit_dets (x_id IN NUMBER)
4673: IS
4674: select DEPARTMENT_ID,START_DATE_TIME,STATUS_CODE,VISIT_TYPE_CODE,AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT
4675: , CASE WHEN UNIT_SCHEDULE_ID IS NOT NULL THEN 'Y' ELSE 'N' END IS_OPERATIONAL_VISIT
4676: from ahl_visits_vl
4677: WHERE VISIT_ID = x_id;-- PRAKKUM :: 13-FEB-2011 :: Bug 13711800
4678: