APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_VISITS_B
Line 1485: l_visit_status ahl_visits_b.status_code%TYPE;
1481: WHERE UNIT_EFFECTIVITY_ID = p_ue_id
1482: AND UNIT_DEFERRAL_TYPE = 'INIT-DUE';
1483:
1484: l_unit_deferral_id NUMBER; 1485: l_visit_status ahl_visits_b.status_code%TYPE; 1486:
1487: BEGIN
1488:
1489: IF G_DEBUG = 'Y' THEN
Line 1897: l_visit_status ahl_visits_b.status_code%TYPE;
1893: TYPE nbr_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1894: l_delete_ue_id_tbl nbr_tbl_type;
1895: l_index number := 0;
1896: 1897: l_visit_status ahl_visits_b.status_code%TYPE; 1898:
1899: BEGIN
1900:
1901: IF G_DEBUG = 'Y' THEN