APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_VISITS_B
Line 1885: l_visit_status ahl_visits_b.status_code%TYPE;
1881: WHERE UNIT_EFFECTIVITY_ID = p_ue_id
1882: AND UNIT_DEFERRAL_TYPE = 'INIT-DUE';
1883:
1884: l_unit_deferral_id NUMBER; 1885: l_visit_status ahl_visits_b.status_code%TYPE; 1886:
1887: BEGIN
1888:
1889: IF G_DEBUG = 'Y' THEN
Line 2308: l_visit_status ahl_visits_b.status_code%TYPE;
2304: TYPE nbr_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2305: l_delete_ue_id_tbl nbr_tbl_type;
2306: l_index number := 0;
2307: 2308: l_visit_status ahl_visits_b.status_code%TYPE; 2309:
2310: BEGIN
2311:
2312: IF G_DEBUG = 'Y' THEN