APPS.AHL_PRD_DF_PVT dependencies on AHL_WORKORDER_TXNS

Line 4244: SELECT status_code,last_update_date FROM ahl_workorder_txns

4240:
4241: FUNCTION getLastStatus(p_workorder_id IN NUMBER) RETURN VARCHAR2 IS
4242:
4243: CURSOR last_status_code_csr(p_workorder_id IN NUMBER) IS
4244: SELECT status_code,last_update_date FROM ahl_workorder_txns
4245: WHERE workorder_id = p_workorder_id ORDER BY last_update_date DESC;
4246:
4247: l_junk_date DATE;
4248: l_last_status_code VARCHAR2(30);