DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_VWP_VISITS_PVT

Line 1206: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(vst_id) IS_OLD_VISIT

1202:
1203: -- PRAKKUM :: 14-JUL-2011 :: VWPE 12730539
1204: -- To find whether visit is old or new
1205: CURSOR c_get_old_visit_dets (vst_id IN NUMBER) IS
1206: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(vst_id) IS_OLD_VISIT
1207: FROM DUAL;
1208:
1209: l_is_old_visit VARCHAR2(1) := 'N';
1210:

Line 2279: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(vst_id) IS_OLD_VISIT

2275:
2276: -- PRAKKUM :: 14-JUL-2011 :: VWPE 12730539
2277: -- To find whether visit is old or new
2278: CURSOR c_get_old_visit_dets (vst_id IN NUMBER) IS
2279: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(vst_id) IS_OLD_VISIT
2280: FROM DUAL;
2281:
2282: l_is_old_visit VARCHAR2(1) := 'N';
2283: