APPS.AHL_PRD_DF_PVT dependencies on AHL_WORKORDER_TXNS

Line 4400: SELECT status_code,last_update_date FROM ahl_workorder_txns

4396:
4397: FUNCTION getLastStatus(p_workorder_id IN NUMBER) RETURN VARCHAR2 IS
4398:
4399: CURSOR last_status_code_csr(p_workorder_id IN NUMBER) IS
4400: SELECT status_code,last_update_date FROM ahl_workorder_txns
4401: WHERE workorder_id = p_workorder_id ORDER BY last_update_date DESC;
4402:
4403: l_junk_date DATE;
4404: l_last_status_code VARCHAR2(30);